Assigning Members to the Page Axis

You can assign members to the page axis of a grid. When you select members for the page axis and run the report, the system generates a grid for each page member. If a chart references a grid with multiple page members, a new chart is generated for each page member.

For example, suppose you assign the following members of the Scenario and Entity dimensions to the page axis:

When you view the report, it is formatted and populated with data from all combinations of members on the page axis. The report contains four grids, one for each page member combination.

You can select any combination of the members:

To add or change dimensions that are assigned to the page axis, see Adding Grids.

Note:

In Financial Reporting, the members (and corresponding data) in the page axis are all retrieved when the report is run. Reports with a large number of members on the page axis, may impact performance.

  To assign members to the page axis:

  1. Open a report.

  2. On the Pages bar, select a dimension .

  3. On the formula bar, select the button with the dimension name.

    Note:

    If you know the member names for a dimension, enter the member name into the formula bar text area. For example, for the Measures dimension enter Profit, Sales. Click the check mark, to verify the member selection.

  4. In the Member Selection dialog box, select the members to use on the page axis, and then click OK.