## 3.13.3  SAPGetData
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 or columns. 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.
Note that dimensions you have defined as background filter, cannot be used in member combinations for this formula. However, they can have an influence on the returned measure value.
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 three methods for entering the member combination:
- Enter one parameter as member combination, for example "Region=France;Product=Services" .
- 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.
- Enter a mixture of both: one parameter per dimension/member combination, for example "Region=France";"Product=Services" . This method is used for converting to a formula.
You can use the function SAPSelectMember to simplify the syntax for the formula. When referring to cells using SAPSelectMember, the meta data context is defined, so it is sufficient to only refer to one particular cell. The simplified syntax looks like this: SAPGetData(&lt;data source alias&gt;; &lt;measure&gt;; &lt;cell reference with SAPSelectMember&gt;). Example: H20=SAPGetData("DS\_1";"0Amount";$B1).
## 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: &gt;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.
## Related Information
SAPSelectMember [page 97]