You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI report exported to different tabs in one Excel workbook

in Reporting and Analytics for ERP 1 comment

Summary:

We have a legacy OTBI report that provides GL details for multiple accounts. The analysis only has one table view, however, the table view is separated into sections by account. And when the results are exported to formatted Excel, each account (section) will have its own tab in the same Excel workbook as shown in the screenshot.

So, I tried to replicate the legacy report since I liked how it could export the results to individual tabs. I created a similar table view and divided the table into sections by account. But when the results of my analysis were exported to formatted Excel, all the sections were on one sheet in the Excel workbook, rather than multiple tabs. If I simply copy the legacy report and edit the analysis (say adding or removing accounts), it will still export the results to separate tabs, but it won't if I build a similar report from scratch.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!