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 * |