on 08-07-2012 6:02 PM
Hi
In web intelligence report, in Query Panel. i have selected a dimension in query filter and select it as prompt. So that it asks me to select values of that dimension when the query is run.
Now i select all the values when the prompt comes,when the report refreshes. But when the report is refreshed. In the report i see only some of the values which i have selected not all, for that dimension . And apart form this dimension i have not applied any other query filter.Any reason for this behaviour.Why i am not getitng all the values which i have selected and all the data related to them.
Thanks in advance.
Hi,
R u building the WEBi report on top of SAP BEx query?
If yes:
Check if you have any restriction done at the BEx query.
This might be the reason of not gettting the complete data.
Thanks,
Vinay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vinay and DSP
thanks for the responce. I am making my Webi report from a universe. And there is no self-restrictive join in the universe.
During report refresh when the prompt comes. I can see all the values to select from and I select all of them. But when i check my refreshed report only some values are there for that dimension.
I also tried by selecting some values and then increasing them,by doing multiple refresh.The values in my report also keep on increasing But finally when i select all the values in the prompt. Again in my refreshed report only 25 values come. Is it some bug..?
hi all,
any idea on this..why the all values are not comming in reports and the data related to them, when all the values were selected in prompt.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jaya
thanks for your reply.
i am not using any formula or variable .Just i select all the values when the prompt comes,during report refresh, for the dimension,which is set in query filter. but in my report i dont get all the values which i have selected.
And also there is no other query filter, which might restrict the values selected.
thanks.
Hi Ronny,
http://www.forumtopics.com/busobj/viewtopic.php?t=108228&highlight=userresponse
Please refer the above link.Hope it helps
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.