Asymmetric Report Creation
To create asymmetric reports, you can use several
commands.
- Provided that the Keep/Exclude on Single Member option is selected in the User Options, use the Keep and Exclude commands from the EPM tab. The excluded members are automatically stored in the report and appear in the Excluded Members tab of the Report Editor.
- Exclude members using the Excluded Members tab in the Report Editor.
- Provided that the Expand/Collapse on Single Member option is selected in the User Options, use the Expand and Collapse commands from the EPM tab.
- Delete
Microsoft Office Excel rows or columns.
Note Deleting a row or column can break the excluded member selection.
- Enter members directly in the cells.
Restriction For SAP BW (INA Provider) connections, the above different ways of
creating asymmetric reports are not supported, except for the following:
- Provided that the Keep/Exclude on Single Member option is selected in the User Options, use the Exclude command from the EPM tab. The excluded members are automatically stored in the report and appear in the Excluded Members tab of the Report Editor.
- Exclude members using the Excluded Members tab in the Report Editor.
Example
In the following example, all three product members
(Chips, Cookies and Pretzels) are selected members of the Product.Family
dimension. This is a symmetric axis:
You exclude Pretzels for Canada and Cookies for
USA. This is an asymmetric axis:
Note that this efficient storage choice is also useful when you pivot. For example, if you dragged the Product.Family dimension to the column axis, the members are each displayed once, like this:
