My Oracle Support Banner

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.

Goal

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. 

 

Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.