A member property is an attribute of a dimension member. It provides cube users with additional information about the member. For more information about dimension members, see Defining Dimensions.
In some browsers, member properties can be easily viewed. The method of displaying member properties varies from browser to browser; for example, an end user might right-click a member to view its member properties. This type of presentation makes available useful information about members without cluttering the default view.
Member properties have a variety of uses. In addition to providing information about a member, member properties can be used in queries and thus provide end users with more options when analyzing cube data. Member properties are also the basis of virtual dimensions. For more information, see Virtual Dimensions.
Values for member properties must be read from a column in the same dimension table as the associated members. You create a member property in the Dimension editor by associating the column that contains values for the member property with the level that contains the members. For example, to create the member property Store Type for members of the Store Name level, ensure that the Store Type column is in the same table as the Store Name column, and then insert Store Type as a member property in the Store Name level.
For more information, see Creating Member Properties.