Skip to Content
0

Difference between notified output lines and real output in the report

Jan 26, 2017 at 02:57 PM

15

avatar image

Hello,

After refreshing a BO webi report we could see 9000000 rows from the query result in the data tab. The partial result icon is displayed in the status column as well. However when the same report is extracted in excel it shows only 4000 something rows in the output. Could you please explain this behavior ?

We are on BO 4.1 sp5.

10 |10000 characters needed characters left characters exceeded

how many rows can you see in the report table or cross tab? 4000 or more?

0

I can see 4200 approx. rows to be specific. Is it because the displayed data in the report is only a part of what is fetched from the query?

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Jan 26, 2017 at 03:23 PM
0

Yes,it's depend on the aggregation and how many fields are dragged in the table to see the level of data.

e.g query fetched 1000 rows but in the report you can see 20 rows only.This is depend on the objects and aggregation.if you can see 20 rows in the report and same is coming in the excel 20 then it should be fine.

For partial result uncheck the option in control tab in universe and also check in the webi query properties if rows limit is enabled.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks for your response. The query properties has these options unchecked, I will check at the universe level.

0