I have a report WebIntelligence, when i refresh i get a warning: "Partial Results". I compare the results of the report with SQL execution and they are differents. I suposse that is a configuration on the servers.... or not??
How can i get complete results on the report???
I'm using BO XI 3.0.
Utkarsh Pandey replied
To resolve the error message
Log in to Universe Designer.
Open the universe to which the Web Intelligence document is linked.
Click File > Parameters.
Choose the Controls tab.
Increase the value of Limit size of result set to: parameter.
Alternately, clear the checkbox.
Also check this:
Open the particular Webi report in Modify Mode.
Click on Edit Query.
Click on the Properties Tab beside the Data tab on the left pane.
Under Limits you would find a check box from "Max rows retrieved."
Uncheck it if it is checked.
I hope this should help