Skip to Content

Issues while changing background filter value on a Data Source

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!

error.png (19.8 kB)
error.png (19.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 17 at 08:40 AM

    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?

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • Apr 17 at 11:00 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 18 at 03:13 PM

    Hi Shubham,

    As said Christian you need to reset your DataSource.
    Sometimes it happens and I do not know why. but remember to record the Dimension and background filters that you have in your current SataSource.

    Thanks
    Sepide

    Add comment
    10|10000 characters needed characters exceeded