Modifying a key figures dimension (SAP BW)

A key figures dimension is a collection of facts such as Quantity Sold or Price.

Key figures are related to each other through the regular dimensions. When used in a report or analysis, the key figures dimension shows the value of the query item such as a name or number, or shows null, zero, or invalid. To create reports that fully compare and contrast functional areas, you may need to use more than one key figures dimension in a report.

You can add value by embedding calculations based on existing business rules, such as Profit Margin.

You can also modify the properties for multiple dimensions at the same time Replacing multiple property values.

You cannot define hierarchies or levels for a key figures dimension.

When dimensions are based on SAP BW metadata, you cannot edit the underlying query. However, you can add calculations and filters.

Procedure

Click the key figures dimension you want to modify.
From the Actions menu, click Edit Definition.
Choose the action that you want:
- Embed calculations by clicking Add and then defining the expression Creating a calculation (SAP BW).
- Change the order of measures, items, or calculations by using the arrow buttons. However, if the measure dimension contains a folder, you can change the order only in the Project Viewer.
- Embed filters Creating a filter (SAP BW).
- Test the dimension Testing a dimension or other object (SAP BW).
Click OK.