EPMSuppress
This function enables you to remove rows or columns, based on specified
members.
The members specified can be:
- In the same axis of the report. In this case, you must specify members that are part of the outer dimension.
- In the page axis of the report.
- In the opposite axis of the report.
- Outside of the report.
In order to perform a remove based on members belonging to dimensions that are placed in the current axis, the opposite axis, or outside of the report, you must specify the full member combination. For example: Plan,2004 (see the syntax in the parameter Members in the table below).
If the members specified do not contain any data, the rows or columns are removed.
Additionally, you can specify to remove rows or columns that contain zero values.
Restriction
- If the members specified belong to a dynamic and asymmetric axis, the remove is not performed. Therefore, the relationship Dimension Property and the selection of excluded members on dynamic axis are not supported.
- When performing the remove on both row and column axis, you cannot perform it on the same dimensions if these dimensions are not part of the report (either dimensions from the context or the page axis).
| Parameter | Description |
|---|---|
| reportID | ID of one or more reports. |
| Row | Specify the axis in which the remove will be performed. Enter TRUE for the row axis, FALSE for the column axis. |
| Members | Specify the members on which
the suppress is based. The member syntax is as follows:
|
| SuppressZeroValues | Specify if rows or columns that contain zero values be also removed. |