none
MDX RRS feed

  • Question

  • how to implemented MDX dynamic Scope calculation/Calculation which will evaluate calculated measures and it's grand total irrespective of any selection in row level in Pivot.
    Tuesday, November 27, 2018 8:23 AM

All replies

  • Hi Mukul Pratap sengar,

    As per my understand that you would like to create a calculated measure inside a scope and ignore the filter in pivot table, right? So, did you use exists or existing function in your dynamic member expression? 

    Would you please share your current MDX expressions, sample data and desired result with us so we can provide more helps?

    Regards,

    Pirlo Zhang 


    MSDN Community Support<br/> Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact <a href="mailto:MSDNFSF@microsoft.com">MSDNFSF@microsoft.com</a>.

    Wednesday, November 28, 2018 9:58 AM
  • Hi Pirlo,

    below is the query

    SCOPE([Measures].[ROE Effect in Actual Rate]);

    This =sum(

            EXISTING Descendants(Axis(0).Item(0).Item(0).Hierarchy.CurrentMember,,LEAVES),

            [Measures].[ROE Effect in Actual Rate]);

    END SCOPE;

    Regards, 

    Mukul


    Friday, November 30, 2018 5:10 AM
  • This works only for one dim in pivot, if i am using multiple dim it doesn't work
    Friday, November 30, 2018 5:10 AM