Get

Returns member property value with the default data type or explicit data type or null if property does not exist.

Properties work in reports or calculations with particular members.

Syntax

Member_Expression.Get(Property_Name_String)
Member_Expression.GetString(Property_Name_String)
Member_Expression.GetDate(Property_Name_String)
Member_Expression.GetNumber(Property_Name_String)
Member_Expression.GetBoolean(Property_Name_String)

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

Arguments

Member_Expression	MDX expression that returns a member.
Property_Name_String	String expression of a member property name.

Examples

Issue created date

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

[Issue].CurrentHierarchyMember.GetDate('Created at')

Both will return the date format value.

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

Fix Version status

To get the status as property for Fix Version dimension members at the version level (similar to Affects Version dimension members) is with this formula:

[Fix Version].CurrentHierarchyMember.Get('Status')

or

[Fix Version].CurrentHierarchyMember.GetString('Status')

Filter Sprints by status and start/end dates

Properties are often 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 the 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.

Resolution date and status of linked issue

If you have a dimension representing linked issues, like the calculated field "All Links" as in this example, you can access the linked issue properties. Use this expression to see the linked issue Resolved date:

[All Links].CurrentHierarchyMember.Get('Resolved at')

Use this expression to see the latest status of the linked issue:

[Status].[Status].GetMemberNameByKey(
  [All Links].CurrentHierarchyMember.Get('Status ID')
)

You can use a similar approach for issue link dimension.

Note that eazyBi can show issue properties only for the linked issues if those are also imported in the "Issue" dimension.

Get