Yes I have an action created. Below is how it is set up. I am using ASSP stored procedures to call the detail.
Target Type: Cells
Target object: All cells
Condition:
[Measures].CurrentMember IS [Measures].[Salary Local - Termination] or
[Measures].CurrentMember IS [Measures].[Salary USD - Termination] or
[Measures].CurrentMember IS [Measures].[Termination Count] or
[Measures].CurrentMember IS [Measures].[Involuntary] or
[Measures].CurrentMember IS [Measures].[Voluntary] or
[Measures].CurrentMember IS [Measures].[Other] or
[Measures].CurrentMember IS [Measures].[Desired] or
[Measures].CurrentMember IS [Measures].[Undesired]
Type: Rowset
Action expression:
'call ASSP.ExecuteDrillthroughAndFixColumns("'
+ ASSP.GetCustomDrillthroughMDX("
[$Employee].[Employee ID]
, [$Employee].[Company Name]
, [$Employee].[Last Name]
, [$Employee].[First Name]
, [$Employee].[Start Date]
, [$Employee].[Last Day Worked]
, [$Employee].
, [$Employee].
, [$Department].[Department Number]
, [$Department].[Department Name]
, [$Employee].[Supervisor]
, [$Division].[Division Name]
, [$Measures].[Voluntary]
")
+ '")'