hi,
I am trying to understand the exact function of
Univ Limit size of result set and
Webi Max Rows retrieved
I am able to have the value of Webi Max Rows retrieved(say 1000)>Univ Limit size of result set(say 100) but the no of rows in the report is still 100.
can some one put it clear, the exact function of both the properties and also what would be the idle value to have on “Univ Limit size of result set”(is it ok if we have it as 500k)
user_4880 (BOB member since 2012-09-17)
There is no connection between Universe row size limit and WebI max row retrieved, they are entirely independent.
For example, Before you generate a WebI report, assume that you wrote a query first using an SQL Tool to query the database to get the result set, assume you got 10 rows. Now, you want to make sure that your WebI report(or query) also retrieves the same no. of rows, that is 10. It just provides that information on the WebI side. This will not show or display any message.
On the other hand, Universe limit is applied to every query if it is set. Whatever the universe row size limit, that is the max you can retrieve using that Universe. Supposedly, If your query has more rows than Universe limit size, then it will throw a message partial result set when you run a webi report. It will provide this information to the user with that we can infer that some of the calculations like totals or averages or any other calculations may not exactly match in the WebI report because all the rows have not retrieved.
Hope that helps.
BO_Chief 
(BOB member since 2004-06-06)
thanks fo the explanation. I was confused because I was able to have the value of Webi Max Rows retrieved greater than the Univ Limit size of result set.
and also can you suggest on what can be the idle value to have for the Univ Limit size of result set.
user_4880 (BOB member since 2012-09-17)