Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BO webi report export to excell no data available in sheet 2 and 3

Hi Team,

I have seen the weird issue, while exporting the report with 3 sheet to excel.

I can see the output only sheet 1 and I could not see the data in sheet 3 & 4 but I can the blank report table.

Please suggest if anyone face this issue earlier.

Root cause analysis done till now

1) I have validated the supported Ms excell compatibility with BI 4.1

2) Checked the data in source system (i.e SAP BW infocubes/Bex queries...connections...etc, data is avaialble)

3) validated the data availability of all sheets in BO Webi and it is available and same is not available in MS excell sheet 2 & 3

Environment

SAP BW 7.4

BO 4.1

Webi rich client

Thanks in advance, please suggest

Regards,

Former Member
Former Member replied

Hi Team,

Issue resolved.

This issue was related to BusinessObject Administrator, As the BO is installed in Linux environment the logs are pilling up and it indirectly impacting BO products.

BO Admin delete obsolete logsĀ  in Linux and restarted Webi server instances, and now we can able to see the data on all the pages.

Thanks

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question