Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Returns all property names and values for a member.

Syntax

...

Code Block
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.

...

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

Code Block
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 
...