AllProperties

AllProperties

Returns all property names and values for a member.

Syntax

Member_Expression.AllProperties

Arguments

Member_Expression

MDX expression that returns a member.

Examples

AllProperties can be used to get list of all available member properties and their values.

For example, [Invoice].CurrentHierarchyMember.AllProperties will return all available properties and their values for the current Invoice dimension member.

Here is an example partial output of AllProperties function for the Invoice dimension member with the key 20150013:

KEY: 20150001 Invoice date: 2015-01-01 Invoice type: Cash Customer code: 019 Customer name: Pink Snack Bar Person code: AM Sales group code: Due date: 2015-01-01 Currency: GBP Currency rate: 1.0 ...