cancel
Showing results for 
Search instead for 
Did you mean: 

Partail Result set in Propmts of WebI Report

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

I resolved this problem thanks all for your responses.

IngoH
Advisor
Advisor
0 Kudos

Hi,

so you created a prompt youself in Web Intelligence or in the Universe ?

Ingo

Former Member
0 Kudos

I created Prompts in WebI Report, and got Partail Results for that.

But, Prompts available in Universe are directly coming from BI Query, which doesnot give partail results.

IngoH
Advisor
0 Kudos

Hi,

could you provide more details on the prompt that you created ?

Ingo

Former Member
0 Kudos

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>

Former Member
0 Kudos

Hi,

Prompt is not created at Universe level its at Report Level.

I have dragged the Object say "Notification Number" (Which is available as Charactrestic in BI Query) in Condition pane of WebI and made it availble as Prompt.

Former Member
0 Kudos

HI ingo,

Any Suggetions on this???

I am stuckup with partail resuls for lOV of few objects.

Former Member
0 Kudos

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.

IngoH
Advisor
0 Kudos

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

Former Member
0 Kudos

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