Skip to Content
avatar image
Former Member

MDX Eliminating the default "abc.ALL" Value

Hello MDX'ers,

Can anyone guide me on a suitable MDX statement that an help me eliminate summary lines ( abc.ALL) from SAP MDX queries? This default of returning subtotals(=summary lines) per characteristic is causing some trouble.

Many thanks

Ian

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 29, 2008 at 08:08 AM

    Hi

    Example:

    *MEMBERSET(%ACC_MBRS%,"Descendants([Account].[NetIncome],999, LEAVES)")

    *XDIM_MEMBERSET ACCOUNT = %ACC_MBRS%

    Will return all base members of NetIncome account.

    Regards,

    Halomoan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 29, 2008 at 11:46 AM

    Dear Halomoan,

    Thank you for your reply, but I'm afraid I can't get that to work.

    Here is the MDX (via MDXTEST) that I was originally using

    SELECT [Measures].MEMBERS ON COLUMNS,

    NON EMPTY [PA_CMPOCD].MEMBERS * [PA_INVIND].MEMBERS ON ROWS

    FROM [PA_PROC/ZGPRQ_PA_MINI_TEST]

    WHERE { [PA_CMPOCD].[200806], [PA_CMPOCD].[200807] }

    which returns

    **All PO Initial Test Dt All Inv Class

    **All PO Initial Test Dt WithPO NoMA

    **All PO Initial Test Dt WithPO WithMA

    **All PO Initial Test Dt Not assigned

    **Jun 2008 All Inv Class

    Jun 2008 WithPO NoMA

    Jun 2008 WithPO WithMA

    Jun 2008 Not assigned

    **Jul 2008 All Inv Class

    Jul 2008 WithPO NoMA

    Jul 2008 WithPO WithMA

    Jul 2008 Not assigned

    What I need to do is eliminate the [PA_CMPOCD].[All] and [PA_INVIND].[All] members from the results set, therby eliminating all the rows marked "**".

    I can't quite see how to do that using MEMBERSET ( there is no hierarchy ).

    Any further help you can give?

    Thanks

    Ian

    Add comment
    10|10000 characters needed characters exceeded