Web intelligence not retrieving all the data

[#1]

We created a new Web intelligence document base on a universe we created using designer and the SQL generated from the web intelligence document retrieves much more data than the report. Are there limitations on how many rows are retrieved? I have the "limit size for result set" unchecked in designer.

[Former Member]

Graham,

Could it be that the query is returning 200,000 rows and your Webi report is aggregating or grouping the measure by the dimensional objects in the report? Making the number of lines in the report 1000.

Mike

[amrsalem1983]

i've a small idea after all those posts,

if you have a measure like sales, or budget or watever,

get the total, using SUM in the webi report

and get the total using some aggregate function in the SQL, and see if there is any difference.

good luck

Amr