Tuple with more that one hierarchy member

Questions & Answers
1

Hello there,

is there a way to create a tuple with multiple hierarchy members?
I want to create a tuple including all “resolved” statuses (Done,Fixed…)

Something like this:
(
[Measures].[Issues created],
[Resolution].[Done],[Resolution].[Fixed],[Resolution].[Direct resolved]
)

As alternative it would be ok to create a tuple including everything that is not “(unresolved)”.
Is there a way to create such a tuple?

As always: thanks for your help!
Antonio

2

I think you can solve it by creating a new calculated member in [Resolution] that will aggregate it and then use it in the tuple/measures.

For example create [Resolution].[My resolved]:
define-new-member

Aggregate(
  {
    [Resolution].[Done],
    [Resolution].[Fixed],
    [Resolution].[Direct resolved]
  }
)

and then use it in the tuple:

(
    [Measures].[Issues created],
    [Resolution].[My resolved]
)

Have a look at https://youtu.be/KSqzB69f9OI?t=880 at time 14:40 where Lauma uses it to define Top priorities.

2 Likes
3

Thanks @tomas.domagalsky!