EPMAxisOverride
This function overrides one or several dimensions (and their members) for a specified axis (row or column axis).
When you enter the function and then click
Enter, the member override is
reflected in the
EPM pane, but
not in the report. To reflect the override, refresh the report.
| Parameter | Description |
|---|---|
| reportID | ID of one or several reports. Mandatory. |
| row axis | Specify which axis is overriden. Enter TRUE to override the row axis, FALSE to override the column axis. Mandatory. |
| dimension1... to dimension5 | On a Planning and Consolidation connection, specify the dimension name. For other connections, specify the hierarchy name; to specify a hierarchy, enter: dimension.hierarchy. Dimension1 is not mandatory |
| member1... to member5 | Members that override the members currently in the report(s). member1 is mandatory. |
- You can
apply the selection to one or more reports, using the
reportID
parameter. See
EPMDimensionOverride.
Note The master report takes precedence over the other reports.
- For the members parameter, see EPMDimensionOverride.
Restriction
The ID given to a member/dimension/hiercharchy/navigation attribute in the database should not be a keyword.
- To specify a dimension, you can select the cell in which a dropdown list retrieves the dimensions, via the EPMDimensionList function. If another dimension is selected from the dropdown list, the dimension change is taken into account in the EPMAxisOverride function.
Note
- Do not use the EPMAxisOverride function more than once on the same axis and the same report.
- If you enter one function for the row axis and one for the column axis, the row axis takes precedence over the column axis.
Note
- If the description of a member exists in several dimensions, once you have entered the function, a message appears, stating that the description is ambiguous and recommending that you use the ID of the member instead.
- If the ID of a member exists in several dimensions, once you have entered the function, a message appears, stating that the ID is ambiguous and recommending that you use the full unique name of the member instead.