I have the following calculated member in the Issues Dimension in rows:
[Issue].CurrentHierarchyMember.Name MATCHES '.*test results.*'
I want to show the Project that the Issues are in by selecting Project under “All hierarchy level members”. But it looks like I can only choose the calculated member OR Project not both.
So my question is, how can I filter the issues I want in the rows while also displaying the Project that the issues are in (in the rows)?
You are using an aggregation on Issue level for this calculated member. Therefore, you can’t access a level above (project level).
eazyBI typically aggregates members according to their default hierarchy. In this case, the grouping and ordering via project should work still for this calculated member when you are expending it to members level. You can add a calculation to show the project name for any issue:
CASE WHEN [Issue].CurrentHierarchyMember.Level.Name = "Issue" THEN
Daina / firstname.lastname@example.org