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.

[howsy]

Dear Subham,

please go to the data source and click on "Reset Datasource". If that does not help, try to remove and add the datasource again.
In most cases this helps. (Those errors can occur when you have changed your datasource and afterwards changed the query, so that you have infoobjects stored in the datasource, which are already gone).

Regards,
Chris

[shubham_chawla]

Thanks for you reply Christian. there's an issue with my data source 🙂