• 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].[Working Title]

    , [$Employee].


    , [$Employee].[Location ID]

    , [$Department].[Department Number]

    , [$Department].[Department Name]

    , [$Employee].[Supervisor]

    , [$Division].[Division Name]

    , [$Measures].[Voluntary]

    ")

    + '")'