Filter not working for a Webi report

[shiva_m]

Hi There,

We have a BOBJ Webi report having variable selection screen when I run the report with default fiscal year Ex.2012 it's working fine. Then by click on refresh button and trying to change selection value to Ex. 2013 and I'm unable to see any values even though it has values for 2013.

When I click on the filter bar then the values are appearing. Could anyone please let me know what could be the reason for this issue and how can we avoid this.

We are in BOBJ 4.0 SP6.

Thank you,

Regards,

Shiva

[shiva_m · Accepted solution]

Hi

Issue has been resolved.

Once I get values for 2014 by click on filter bar, I saved the webi report and closed. Now on 2014 will be the default value for this report and it's giving output even if you refresh and give for 2012 also values are displaying without clicking on the filter bar.

Regards,

Shiva

[Former Member]

Hi Sheva,

your descriptions is not much clear, screenshots would be useful - query definition and report structure.

Also check if there is no untintentional filter on the table (basic or set from input controls...)

J.

[shiva_m]

Hi Jakub,

Thanks for the reply, Please find the screen shots below

1. Report initial screen running with the default prod year for 2012 and it's working.

2. Then I click on refresh and run for another prod year it's not displaying values even though it has values for that prod year.

3. When I click on filter bar then the values are appearing. Not sure why it's behaving like this?

Also note that there is no filter, under query filters. Please give me any idea about this issue.

Regards,

Shiva

[Former Member]

Shiva, are you sure you see the whole table? There may be other pages where is the rest of your data. Furthermore - is data defined only by one query? If you cannot see 2013 in prompt window then problem may lay in the universe. If you are familiar with Microsoft remote assistance (MSRA) you may send me ticket for allowing me to see what you see.

J.

[shiva_m]

Thanks for your prompt response Jakub,

Yes on the initial screen I can see whole data for 2012 but when I changed it to 2014 after webi refresh I'm unable to see data on a whole table until I click on filter bar and choose for 2014. Not sure why it's happening for this report only. Please give me any idea.

Regards,

Shiva

[Former Member]

Is your source SAP BW? If yes please check this document:

https://websmp106.sap-ag.de/~sapidb/011000358700001253212012E/xi4_release_notes_en.pdf

I guess one of ADAPTs might be your case...

[Prabhith]

Hi Former Member,

Sorry, just a very basic question from my side,

Your first screen shot also don't have 2013 in the LOV. Why is that so?

BR

Prabhith