List of values showing Partial Results

[Former Member]

Hi,

List of values for one of my Key column is showing Partial Results. I have made the below settings both in IDT and CMC but still showing partial results.

IDT:

In Business Layer under Query Options> Query Limits> I have unchecked the "Limit size of Result set to" and "Limit Execution time to"

CMC:

Under Applications > WebIntelligence> Properties> Quick Display Mode> I have changed the value to 100000

But still I am getting the partial results. Is there any setting or steps that i need to take care of.

Can any one provide their ideas if some one has faced the similar issue.

Thanks

[Prabhith]

Hi Former Member,

I believe the default LOV size for webi is 1000.

Normally,, we increase the  LOV size through CMC--> servers --> WEBI --> Properties --> maximum LOV size. Save and restart,

This change in settings can affect performance,...

BR

Prabhith

[Former Member]

Hi SS R,

Try the following:

1. Set the MAX_INLIST_VALUES parameter in universe to -1.

2. Uncheck the "Limit result set to" option in Universe Parameter --> Control tab.

Regards,

Yuvraj

[Former Member]

Hi,

I dont have any filters.

[former_member4998]

Hi

After Changing the setting also getting the partial results.....then check if there any filters applying while running the Q's