Show TOC

SAPGetDataLocate this document in the navigation structure

This function returns the measure value for a specific dimension member combination.

The formula can return values only 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. For example, if the navigation state of the data source displays the dimension 'Region' in rows and the measure 'Sales Volume' in columns, you can create a formula to return a value for a particular region, but you cannot return a value for a special customer, even if customer information is available in the data source. To be able to return values for a special customer, you have to add the dimension to the navigation state, for example as a background 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 "Incoming Orders".

  • Member combination

    There are two methods for entering the member combination:

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

Example:

3 Parameters Formula

Cell H20: =SAPGetData("DS_1";"Incoming Orders";"Region=France;Product=Services")

The data for the value in this cell comes from data source DS_1. The name of the measure is 'Incoming Orders'. The member combination is 'France' and 'Services'. The formula in cell H20 therefore uses the data from DS_1 to calculate the incoming orders for region 'France' and product 'Services'. If you change 'France' to 'Germany' in the formula, the incoming orders for Germany and Services are displayed in cell H20.

Example:

>3 Parameters Formula with Cell Reference

Cell H20: =SAPGetData("DS_1";"Incoming Orders";"Region";B10;"Product";"Services")

The data for the value in this cell comes from data source DS_1. The name of the measure is 'Incoming Orders'. The member combination is the region entered in cell B10 and 'Services'. For example, if you enter 'Spain' in cell B10, the formula in cell H20 uses the data from DS_1 to calculate the incoming orders for region 'Spain' and product 'Services'. If you change 'Spain' to 'France' in cell B10, the incoming orders for 'France' and 'Services' are displayed in cell H20.