Issues by label report not working

Questions & Answers
1

Hey there,
I have a report I am trying to run which seems reasonably simple to me, but unfortunately doesn’t work. Will try and explain what I want and what I did.

I have 3 labels: A, B, C and I want a report over time, every month how many got label C out of A+B+C and how many got A or B out of the same total. (Want to display it as stacked bars)

What I did was defined 2 calculated members in Label:

  • ABC - Aggregate({[Label].[A], [Label].[B], [Label].[C]})
  • AB - Aggregate({[Label].[A], [Label].[B]})

I added a calculated member on Issue named ABC:

NonZero(
Count(
  Filter(
    Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
    ([Measures].[Issues created],
    [Label].[ABC]) > 0)
))

(When I define this I get a warning:

Do not use the other dimension Measures, Label when defining a calculated member in Issue . Create complex calculations in Measures

how can I do it otherwise?)

And finally I added 2 measures:
AB:

Count(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]), 
    ([Measures].[Issues created], 
    [Label].[AB]) > 0
    )
)

C:

Count(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]), 
    ([Measures].[Issues created], 
    [Label].[C]) > 0
    )
)

Both measures give me blank (or zeroes if I remove the NonZero). Why?

Thanks ahead,
Uri

1 Like
2

I now tried a much simpler approach:

Changed the ABC calculated member on Issue to be:

[Label].[ABC]

And changed the measures to be:

AB:

([Measures].[Issues created], 
 [Label].[AB])

C:

([Measures].[Issues created], 
 [Label].[C])

I added also the measure Issues Created.

So I get the right value in Issues created, but in the columns AB & C I get the same value as issues created.

If I run the report on All Issues instead of on ABC, I get different values in each column (didn’t check their correction).

So I assume this approach should be better, but I am probably missing something simple

3

Hi @Uris,
you are on the right path in your solution!
-I would suggest using measure Issues created count that is a distinct or unique issue count measure.
-Also, my suggestion would be to aggregate Labels ABC together in Label dimension

Aggregate({
  [Label].[A],
  [Label].[B],
  [Label].[C]
  })

-Then use this member together with Issues created count in a tuple in Measure dimension (never use Issue dimension for MDX formulas that reference members from other dimensions).

(
  [Measures].[Issues created count],
  [Label].[ABC]
)

To get Labels C, use a similar approach:

(
      [Measures].[Issues created count],
      [Label].[C]
)

For Labels AB use subtraction:

[Measures].[Labels created count (ABC)] - [Measures].[Labels created count (C)]

Best,
Gerda // support@eazybi.com

4

Thanks, that solved it!

1 Like