Page Axis Dimension Members Modification using the Member Selector

You can modify the members for a dimension in the page axis directly from the sheet.

To do so, double-click the member cell. The Member Selector that opens is a sub-section of the one opened from the Report Editor or the EPM pane.

However, this Member Selector includes an additional option called Allow Multi-Selection. Using this option, you can select several dimension members for a page axis dimension. When you select several members, the data on the members is automatically aggregated in the report.

When the Allow Multi-Selection option is selected, the Select all Members option is enabled: you can use it to select in one single click, all the members that are in the list of members of the Member Selector.

Note

When using a Planning and Consolidation , version for SAP NetWeaver connection and provided that the PageAxisSum capability exists on the server side, you cannot select more than 300 members per dimension.
For any other connection, you cannot select more than 30 members per dimension.

Note If you often use a specific selection of members for a page axis dimension, it is recommended that you convert the selection into a custom member.

Note You can display the members in a hierarchy or a list, you can select the member names to display in the report, and you can search for a specific member.

Member Parent Quick Selection in Page Axis

To quickly select the parent member of a member located in the page axis of a report, select the member cell, then click Collapse in the EPM tab: the parent member is displayed instead and is taken into account in the report. This is possible only when a single member is selected for a dimension located in the page axis.