Feature Overview
SAP has added the SAP.MEMBERPROPERTY formula, which returns the value of a specified property for specified dimension members.
![](https://www.analysisprimeuniversity.com/wp-content/uploads/2024/02/41-1-1024x862.png)
The information in the image above was provided by SAP’s Help Portal. Check out the ‘SAP Analytics Cloud Help Documentation’ for more details at https://shorturl.at/yHSZ3
Use Case
This function is useful when you want to identify what member IDs contain in a certain property value.
![](https://www.analysisprimeuniversity.com/wp-content/uploads/2024/02/41-2-1024x700.png)
By identifying those member IDs, you can also nest the function inside of another Excel formula. For example, below, I have nested the SAP.PROPERTYMEMBER inside of an If/then statement to return a value for only those account types of income (INC).
![](https://www.analysisprimeuniversity.com/wp-content/uploads/2024/02/41-3-1024x598.png)