This function returns the dimension member or attribute.
The formula can only return values for dimension members or atttributes that are part of the current navigation state of the data source. To be part of the navigation state, the members must be used in rows, columns or as background filter. If you filter a dimension, you can only return values for members that the filter contains.
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 technical name of a dimension and assign a member key, for example "0DIVISION=R1".
You can enter TEXT, KEY or Internal_Key to define how the filtered members should be displayed in the workbook.
Cell G15: =SAPGetMember("DS_1";"0DIVISION=R1";"TEXT")
You want to display the text for member Retail. The key for Retail is R1. If you enter the formula in cell G15, the text of member R1 (Retail) is displayed in cell G15.