Partial Results alert

[S4E]

I am a new user to BO, and I have a question regarding the "Partial Results" alert that flashes at the bottom of my screen after running my query. Is this alert indicating that my query is retrieving more data than can be displayed? I performed a count on one of my columns, and it indicated 5000 rows.

I ran the identical query in Excel, and it returned 4152 rows of data.

Thanks,

S4E

 

[jimbopalmer]

The Designer of the Universe assigns limits to the number of CPU minutes and the number of rows you query is allowed, if either is exceeded, you will only get partial results. In the above example that would appear to be 5000 rows.

I tried to remain child-like, all I acheived was childish.

 

[xlbo]

Partial results means that the query has exceeded a parameter set (as per above) in the universe / user profile - this can either be set on no. of rows or no. of minutes of execution. Either way, it means that you have NOT got a full set of data being returned.

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question