Drill down in fusion BIP Reports
Summary
Using drill down functionality in BIP Reports (using BIP template and output in excel)Content
Hi,
Does anyone use drill down functionality in BIP Reports (using BIP template and output in excel)?
We tried and excel hyperlink works fine if number of rows is less than 65536. When it cross this limit excel gets corrupted and prompts for recovery when we open excel.
Did anyone overcome this issue?
As a workaround oracle SR suggested to use excel template instead of BIP template and split the output into multiple sheets. Our customer don't want this, as it restricts output format to only excel and also don't want to work with multiple sheets of 65k.
1