Returns member property value with default data type or explicit data type or null if property does not exist.
Member_Expression.get(property_name) Member_Expression.getString(property_name) Member_Expression.getDate(property_name) Member_Expression.getNumber(property_name) Member_Expression.getBoolean(property_name)
Function get will work with any data type. You can use others to explicitly set the expected results in a particular data type (String, Date, Number, or Boolean).
|MDX expression that returns a member.|
|String expression of a member property name.|
Properties work in reports or calculations with particular members.
eazyBI imports a set of Jira issue properties in the section Issue properties. The default issue property Issue created date uses the formula
[Issue].CurrentHierarchyMember.get('Created at') or
Both will return the date format value.
Another example to get the email as property for Assignee dimension members at user level (similar with Reporter, Logged By, and Transition Author dimension members) is with this formula:
See example report List of issues in progress in our demo account. The report contains several issue properties to show values for particular issues, including Issue created date.
Properties often are used and suggested for calculated members in dimensions. Sprint members in the Sprint dimension contain several properties usable for creating calculated members in Sprint dimension. The example formula below will filter out all closed sprints from all boards and order them by Sprint start date
Aggregate( Order( Filter([Sprint].[Sprint].Members, [Sprint].CurrentMember.getBoolean('Closed') AND NOT IsEmpty([Sprint].CurrentMember.get('Complete date'))), [Sprint].CurrentMember.get('Start date'), BASC ) )
See sample report Sprint Velocity chart in our demo account. The default calculated member All closed sprints is used on Rows. It is expanded to sprint level and then removed. eazyBI will automatically update the report based on this calculated member filter criteria with newly closed sprints.
Function AllProperties can be used to see a list and values of all available properties.