[EazyBI] Arbitrary grouping dimension members

Jerome Renaud

Hi All,

Simple question that puzzles me: I want to arbitrary group several dimension members (for example ticket reporters). I do it frequently with MS Excel, but I have absolutely no clues on how to do it with EazyBI and I failed finding it in the documentation.

Thank you for your help!

Lauma Cīrule

Hi Jerome!

To group several dimension members you can use the Aggregate(set) MDX function in eazyBI dimension calculated members where you wish to group some members.

For example, if I would like to aggregate two reporters with JIRA user display names John and Anne, then the formula in Reporter dimension would be as follows

Aggregate({
  [Reporter].[Anne],
  [Reporter].[John]
})

Or you can also use the Filter for all dimension members and only find the ones that match some condition. See examples about reports using JIRA user groups.

Let me know if you have additional questions!
Lauma