Export Multigrid Financial Reporting (FR) Report To Excel With Page Axis Members In Separate Tabs
(Doc ID 2765954.1)
Last updated on APRIL 01, 2021
Applies to:Oracle Planning and Budgeting Cloud Service - Version 18.01.42 to 21.03.54 [Release 18.0 to 21.0]
Oracle Financial Consolidation and Close Cloud Service - Version 18.01.42 to 21.03.54 [Release 18.0 to 21.0]
Information in this document applies to any platform.
A multigrid FR report has each grid's Pages axis containing various select members belonging to the same dimension. In addition, the "Page Break Before" option is enabled for each grid. Excel export of this multigrid report shows fewer tabs in the worksheet. For example, each tab contains grouping of Pages axis members from each different grid.
The main objective is for each tab in the worksheet to display each Pages axis member associated data. For example, first tab would display data associated with first Pages axis member from Grid1. The second tab would display data associated with the next Pages axis member from Grid1. Next, third tab would display data associated with the first Pages axis member from Grid2 and so forth.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document