Hi,
I wanted to create a measure that filters the report data to show bugs only and in status “open” or “code review”, I used tuples to ensure the report is filtered for better performance
I tried the below code, but I get an error saying “Formula is not valid: Tuple contains more than one member of hierarchy ‘[Status]’.”
([Issue Type].[Bug],
[Status].[Open],
[Status].[Code Review],
[Measures].[Issues created]
)
How can I do that?
Hi motagaly,
Welcome to the eazyBI community!
To create a measure that filters for bugs in either “Open” or “Code Review” status using tuples, you’ll need to follow these steps:
(1) First, create a calculated member in the Status dimension that aggregates the “Open” and “Code Review” statuses. You can do this by adding a new calculated member with the following formula:
Aggregate({[Status].[Open], [Status].[Code Review]})
You can name this calculated member, for example, “Open or Code Review”.
(2) Once you have created this calculated member, you can use it in your tuple like this:
(
[Issue Type].[Bug],
[Status].[Open or Code Review],
[Measures].[Issues created]
)
Tuples can only contain one member from each dimension, which is why your original formula resulted in an error. We can work around this limitation by aggregating the status values into a single calculated member.
More about tuples and calculated members here:
Tuple documentation
Calculated members in other dimensions documentation
Best,
Ilze