1. User's Guide
  2. Defining Members
  3. Assigning Members
  4. Assigning Members to the Page Axis

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, a grid is generated 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, assume that you assign the following members in the Scenario and Entity dimensions to the page axis:

  • Target 1 and Target 2 in the Scenario dimension

  • Radio Promotions and Web Promotions in the Entity dimension

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.

In this example, you could select any combination of the members:

  • Target 1: Radio Promotions

  • Target 1: Web Promotions

  • Target 2: Radio Promotions

  • Target 2: Web Promotions

Note:

In Oracle Hyperion Financial Reporting, all the members and corresponding data in the page axis are retrieved when the report is run. As a result, performance may be impacted for reports with a large number of members on the page axis.

To assign members to the page axis:

  1. Open a report and select a grid.
  2. In the Pages drop-down list, select a dimension.
  3. On the formula bar, select the button with the dimension name.

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

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