I have a cascading select custom field, “Root Cause Selection”. The import from Jira is set up as:
I would like to have a report that lists the Transition Author and the date the selection was made. I have been able to get everything but the Transition Author.
Where the measure RootCause is:
Both Project and Status listed are aggregates I use often.
(
[Project].[NonQA Projects],
[Issue Type].[Defect],
[Status].[PreTestReadyDefects],
[Measures].[Issue Root Cause Selection]
)
Date set is:
TimestampToDate(
(
[Measures].[Transition to last timestamp],
[Transition Field].[Root cause selection]
)
)
and Set by is:
[Transition Author].[User].Name
I have tried:
1: Using the Transition Author dimension in the Rows
This causes the report to time out
2: Variations of the above measure (i.e. CurrentMember, CurrentHierarchyMember, etc) with and without listing [Transition field].[Root Cause Selection]
Naming the transition field causes the column output to go blank.
Please tell me what I am missing, OR if it’s just not possible, I would love some validation on that so I can stop trying 
THANK YOU eazyBI support team!!
