Document toolboxDocument toolbox

AllProperties

Owned by Elvis Kvalbergs
Last updated: Aug 03, 2022 by Gvido

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