Show TOC

SAPGetMemberLocate this document in the navigation structure

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.

The formula consists of 3 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.

  • Dimension Member

    Enter the technical name of a dimension and assign a member key, for example "0DIVISION=R1".

  • Member Display

    You can enter TEXT, KEY or Internal_Key to define how the filtered members should be displayed in the workbook.

Example

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.