Issues while changing background filter value on a Data Source

[shubham_chawla]

I have a dashboard on Lumira Designer 2.1 which is having multiple data sources. I am trying to put a filter on one the data sources but getting the error attached in screenshot.

I have a copy of this dashboard where I am putting the filter of same attribute but having different value, its working absolutely fine but for this dashboard its giving error

Attribute Value = 10 or 20 or 30 are working fine

but if Attribute Value = 50, then the issue arises

Any suggestions on this would be much appreciable. Thanks!

[arijit_das]

Looks like the error is coming from backend. Did you try to create a webi / Analysis Office report on top of the same data source and same filter ?

[TammyPowlas]

Additionally did you update to 2.1 SP1? What version/SP of the BI Platform are you using?

[shubham_chawla]

yes, the issue is on BW, when I am running the query on rsrt its generating the same error "Numeric overflow". Any suggestions on this?

[shubham_chawla]

I am currently on SP0, will soon update it to SP1.

[Former Member · Accepted solution]

What is the source of the datasource? If it is a BW report, can you try executing it for the same filter for which you are getting issues?

[shubham_chawla · Accepted solution]

Hi Shwetha,

Exactly, I tried running my query in rsrt and replicated the issue. but its happening for one particular value, if I am selecting any other value for selection then its working fine.

My guess is, on selecting the particular value for which error is coming, some KPIs are getting zero, and may be these KPI are getting used as denominator in another formula in BEx.