Show TOC

SAPGetUniformScalingLocate this document in the navigation structure

This function returns the unit/scaling information for a specific dimension member combination.

The formula can only return values for member combinations that are part of the current navigation state of the data source. To be part of the navigation state, the member combinations must be used in rows, columns, or as a background filter. If you filter a dimension, you can return values only for member combinations contained in the filter.

The formula consists of at least three parameters and is made up of the following arguments:
  • Data Source

    Enter the formula alias for the data source. You can set the alias when configuring the data source on the Components tab in the design panel.

  • Measure

    Enter the name of measure, for example "Sales Volume".

  • Member combination

    There are two methods for entering the member combination:

    • Enter one parameter as member combination, for example "Region=France;Product=IT". This method is used for converting to a formula.
    • Enter several parameters as the member combination, for example "Region";"France";"Product";"IT". This method can only be entered manually. It is recommended for member combinations that use cell references.

Example

3 Parameters Formula

Cell H20: =SAPGetUniformScaling("DS_1";"Sales";"Region=France;Product=IT")

The data for the value in this cell comes from data source DS_1. The name of the measure is 'Sales Volume'. The member combination is 'France' and 'IT'. The formula in cell H20 therefore uses the data from DS_1 to calculate the unit/scaling factor for the sales volume for region 'France' and 'IT' (e.g. EUR). If you change 'France' to 'USA' in the formula, the unit/scaling factor for the sales volume of 'USA' and 'IT' is displayed in cell H20 (e.g. USD).