MDX Eliminating the default "abc.ALL" Value

[Former Member]

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

[Former Member]

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

[Former Member]

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