All eazyBI for Jira eazyBI for Confluence Private eazyBI

AllProperties

EAZYBI Returns list of all property names and values for a member.

Syntax

 Member_Expression.AllProperties

Arguments

Member_ExpressionMDX expression that returns a member.

Examples

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

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

Here is an example partial output of AllProperties the function for the Issue dimension member with the key ANERDS-1:

KEY: ANERDS-1
DISPLAY_KEY: ANERDS-1
Created at: 2011-05-25 06:32:12
Updated at: 2012-10-23 18:15:08
Updated at UTC: 2012-10-23 18:15:08
Status updated at: 2011-10-24 03:04:19
Resolved at:
Closed at:
Due date:
Reporter name: anton@atlassian.com
Assignee name:
Issue type ID: 1
Priority ID: 2
...

See also

  • Use function Get to access a particular property within a calculation. 
  • Function CurrentHierarchyMember to address the member on report rows, columns, or page selection.