BO webi report export to excell no data available in sheet 2 and 3
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
SAP BW 7.4
Webi rich client
Thanks in advance, please suggest
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.