on 12-29-2011 8:49 PM
After refreshing data in WEBI report yellow triangle is displayed with worning message 'Partial Results'.
WEBI report was built on top of MS SQL based universe and BOBJ version 4.0. Univers was built using Information Design Tool.
In Query properties 'Max Rows retrieved' and 'Max retrieval time' are unchecked.
What needs to be done to eliminate 'Partial Results' warning?
PS. Solution suggestions based on 3.x posts did not help
Hi all-
Glad to find this post. Using the older Universe Designer I found that in File>Parameters I had a search return limit of 5K records in one of my linked universes. I lifted the attenuator by unchecking it and my report now returns expected results.
Thank you all for sharing!!
Patti Ciavarelli
Senior Research Analyst
Pratt Institute
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, can someone help me with your knowledge.
I've chagned the max row limit in all three settings
1) Business Layer 'Query Options'
2) CMC - Manage - Applications - Webi - Quick display mode
3) Report - Query Panel - Query properties
But it still shows partial results. I don't know what's going on? Is there a way to track it down where it's restricting the result set?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ravi ,
Make sure you did unchecked limit size of result set and Limit Execution time in Business Layer properties in production environment.
Check no of rows returned in webi (use Querysummary()) .
Execute the SQL webi generated in database and check for no .of rows .
If you are using multiple Business layers ,make sure this changes applied in all .
Hi,
Did you try changing the properties in CMC for Webi Application under:
Quick display mode properties as it has got the max number of rows option to set it up to max of 100,000.
Thanks,
Suresh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Forgot to mention one more option.
In Webi Report Design mode of the Query not the report, there is a Icon which says Query Properties and this
has got the Max rows retrieved default to 5000 to all globally.
Check the radio button and change it to any number and you are good to go.
recommendation is to change both at CMC level and the above step too so that it won't bypass.
Thanks,
Suresh
please consult the Information Design Tool Guide at page 153
http://help.sap.com/businessobject/product_guides/boexir4/en/xi4sp2_info_design_tool_en.pdf
another level at which you can limit the number of rows returned from a Database or the time is in the Query Properties in the Web Intelligence designer tools (Rich Client, Web, etc)
| 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.