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.
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.
Enter the name of measure, for example "Incoming Orders".
There are two methods for entering the member combination:
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.
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.