on 08-05-2009 11:01 PM
Hi,
I have an issue with List of values of some objects in WebI Report created on Universe which is built on Top of SAP BI Query.
If Prompts are defined at WebI level (for some objects), I donu2019t see all LOV for that object, I see the Symbol of Partial Results after refreshing the LOV of that Prompt.
If the Prompts are defined in SAP BI Query, I get entire LOV for those prompts in WebI.
Also, I have checked in the Universe Parameters Tab there is no restriction on the result set.
The partial results appears only for few object , it doesnot happens with all the objects.
Are there any settings needs to be done at Universe level or at WebI level to remove the Partial Results for those objects?
regards,
Nisha
Edited by: Nisha Makhija on Aug 6, 2009 12:11 AM
I resolved this problem thanks all for your responses.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
so you created a prompt youself in Web Intelligence or in the Universe ?
Ingo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Could you please paste here MDX code for that filter.
It seems , As you have created a prompt at your own there might be some issue
1. Did its parsing is ok ?
Also make sure you have the proper syntex like for mandotary fiter.
FILTER KEY="@Select(Division\L01 Division)"><CONDITION
OPERATORCONDITION="Equal"><CONSTA
NT CAPTION="@Prompt('L01
Division','A','Division\L01
Division',mono,constrained)"/></C
ONDITION></FILTER>
Nisha,
Can you make sure that there is no restriction on that characteristic based on any key fig in query which restricts the LOV and showing you the partial result.
Bcoz if you restricts characteristic value based on any key fig and once you drag that key fig in query panel and characteristic in prompt area then it will show the partial result.
Hi Nisha,
couple of questions:
- what does the query contain overall : rows, columns, free characteristics, variables, flters, default values ?
- any additional prompts or filters in the Universe ?
- you mentioned that you created the filter in the report : Did you use the filter option in the query Filter objects in the query panel ? or the Filter panel in the report ? or the report filter panel ?
in case you not sure about the last question perhaps take a screenshot and attach it here.
Ingo
Sorry for the delayed respond.
I investigated about this issue, I found there is one option for List of Values Limit in WebIntellegence processing server in CMC.
I increased the limit from 50000 to 1000000, as we have millions of records in source. and the issue which i was getting i.e. Partial Results symbol for some of the prompts is gone now...!! My problem got resolved.
May be I get Performance issues!!! but need to testing on that.
Edited by: Nisha Makhija on Sep 3, 2009 9:17 PM
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.