MDX Statement that was executed:
SELECT NON EMPTY {[Measures].[0D_QUANT_B], [Measures].[0D_COSTVALS]} ON AXIS(0), NON EMPTY {[0D_DIS_CHAN].[All]} ON AXIS(1) FROM [$0D_SD_C03] WHERE ([0D_DIV].[7], [0D_VERSION].[000], [0D_VTYPE].[010]) CELL PROPERTIES CELL_ORDINAL, VALUE, FORMATTED_VALUE

Result set:

  Quantity in base units (SAP DEMO) Cost in statistics currency (SAP DEMO)
All Distribution channel 558,507 PC 504,231,497.05 *

MDX Statement that was executed:
SELECT NON EMPTY {[Measures].[0D_QUANT_B], [Measures].[0D_COSTVALS]} ON AXIS(0), NON EMPTY [0D_DIS_CHAN].[All].CHILDREN ON AXIS(1) FROM [$0D_SD_C03] WHERE ([0D_DIV].[7], [0D_VERSION].[000], [0D_VTYPE].[010]) CELL PROPERTIES CELL_ORDINAL, VALUE, FORMATTED_VALUE

Result set:

  Quantity in base units (SAP DEMO) Cost in statistics currency (SAP DEMO)
Direct Sales 85,983 PC 47,724,456.10 *
Final Customer Sales 284,681 PC 212,380,520.15 *
Sold for resale 184,459 PC 240,217,648.80 *
Service 3,384 PC 3,908,872.00 *

MDX Statement that was executed:
SELECT NON EMPTY {[Measures].[0D_QUANT_B], [Measures].[0D_COSTVALS]} ON AXIS(0), NON EMPTY [0D_DIS_CHAN].[1].PARENT.FIRSTSIBLING:[0D_DIS_CHAN].[1].PARENT.LASTSIBLING ON AXIS(1) FROM [$0D_SD_C03] WHERE ([0D_DIV].[7], [0D_VERSION].[000], [0D_VTYPE].[010]) CELL PROPERTIES CELL_ORDINAL, VALUE, FORMATTED_VALUE

Result set:

  Quantity in base units (SAP DEMO) Cost in statistics currency (SAP DEMO)
All Distribution channel 558,507 PC 504,231,497.05 *

MDX Statement that was executed:
SELECT NON EMPTY {[Measures].[0D_QUANT_B], [Measures].[0D_COSTVALS]} ON AXIS(0), NON EMPTY DRILLDOWNMEMBER([0D_DIS_CHAN].[1].PARENT.FIRSTSIBLING:[0D_DIS_CHAN].[1].PARENT.LASTSIBLING, {[0D_DIS_CHAN].[All]}) ON AXIS(1) FROM [$0D_SD_C03] WHERE ([0D_DIV].[7], [0D_VERSION].[000], [0D_VTYPE].[010]) CELL PROPERTIES CELL_ORDINAL, VALUE, FORMATTED_VALUE

Result set:

  Quantity in base units (SAP DEMO) Cost in statistics currency (SAP DEMO)
All Distribution channel 558,507 PC 504,231,497.05 *
-- Direct Sales 85,983 PC 47,724,456.10 *
-- Final Customer Sales 284,681 PC 212,380,520.15 *
-- Sold for resale 184,459 PC 240,217,648.80 *
-- Service 3,384 PC 3,908,872.00 *
-- #

MDX Statement that was executed:
SELECT NON EMPTY {[Measures].[0D_QUANT_B], [Measures].[0D_COSTVALS]} ON AXIS(0), NON EMPTY DRILLUPMEMBER(DRILLDOWNMEMBER([0D_DIS_CHAN].[1].PARENT.FIRSTSIBLING:[0D_DIS_CHAN].[1].PARENT.LASTSIBLING, {[0D_DIS_CHAN].[All]}), {[0D_DIS_CHAN].[All]}) ON AXIS(1) FROM [$0D_SD_C03] WHERE ([0D_DIV].[7], [0D_VERSION].[000], [0D_VTYPE].[010]) CELL PROPERTIES CELL_ORDINAL, VALUE, FORMATTED_VALUE

Result set:

  Quantity in base units (SAP DEMO) Cost in statistics currency (SAP DEMO)
All Distribution channel 558,507 PC 504,231,497.05 *