All eazyBI for Jira eazyBI for Confluence Private eazyBI

Get

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

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

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 [Issue].CurrentHierarchyMember.GetDate('Created at')

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: [Assignee].CurrentHierarchyMember.Get('Email') or [Assignee].CurrentHierarchyMember.GetString('Email')

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.


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.  

See also