BI Tips: Using Member Properties

In your BI environment there are many data-points that may not be displayed out in the open.

Member properties are hidden within the member they relate to. These properties can then be used within your report as a calculated member.

How do I find them?

Navigate to the lowest level where the members displayed. This is normally represented by a single dot. (Examples below.)

UsingMemberProperties1.pngUsingMemberProperties2.png

Expand the folder named ​“Member Properties.”

UsingMemberProperties3.pngUsingMemberProperties4.png

How do I use these in my report?

  1. Create a new calculated member.
  2. In the ​“Meta Data” section, navigate to the member property you want to use.
  3. Double-click on that property. The system will auto-populate the needed syntax.
  4. Click OK.
  5. Simple as that!