Show TOC

SAPGetDimensionInfoLocate this document in the navigation structure

This function returns the name of a dimension or the name of an active hierarchy.

The formula consists of 3 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.

  • Dimension

    Enter the technical name of the dimension.

  • Property Name
    You can enter the following property names:
    • NAME
    • ACTIVEHIERARCHY

Example

Cell F20: =SAPGetDimensionInfo("DS_1";"0DIVISION";"NAME")

If you enter the formula in cell F20, the name of dimension 0DIVISION is displayed in cell F20.