MDX Statement that was executed:
SELECT
NON EMPTY {[Measures].[0D_QUANT_B], [Measures].[0D_COSTVALS]} ON AXIS(0),
NON EMPTY [0D_SALE_ORG].MEMBERS 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 Sales organization | 558,507 PC | 504,231,497.05 * |
-- Frankfurt | 21,437 PC | 19,059,594.32 EUR |
-- Berlin | 43,612 PC | 29,128,427.23 EUR |
-- Munich | 56,084 PC | 56,792,116.85 EUR |
-- Hamburg | 22,449 PC | 17,030,564.28 EUR |
-- London | 72,781 PC | £ 38,503,211.00 |
-- Birmingham | 47,300 PC | £ 24,446,569.00 |
-- Paris | 82,001 PC | 77,760,700.37 EUR |
-- New York | 69,538 PC | $ 65,216,274.00 |
-- San Francisco | 22,416 PC | $ 22,293,811.00 |
-- Toronto | 73,933 PC | 83,177,378.00 CAD |
-- Vancouver | 44,397 PC | 66,419,790.00 CAD |
-- Sydney | 2,559 PC | 4,403,061.00 AUD |
MDX Statement that was executed:
SELECT
NON EMPTY {[Measures].[0D_QUANT_B], [Measures].[0D_COSTVALS]} ON AXIS(0),
NON EMPTY ORDER([0D_SALE_ORG].MEMBERS, ([Measures].[0D_QUANT_B]), ASC) 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 Sales organization | 558,507 PC | 504,231,497.05 * |
-- Sydney | 2,559 PC | 4,403,061.00 AUD |
-- Frankfurt | 21,437 PC | 19,059,594.32 EUR |
-- San Francisco | 22,416 PC | $ 22,293,811.00 |
-- Hamburg | 22,449 PC | 17,030,564.28 EUR |
-- Berlin | 43,612 PC | 29,128,427.23 EUR |
-- Vancouver | 44,397 PC | 66,419,790.00 CAD |
-- Birmingham | 47,300 PC | £ 24,446,569.00 |
-- Munich | 56,084 PC | 56,792,116.85 EUR |
-- New York | 69,538 PC | $ 65,216,274.00 |
-- London | 72,781 PC | £ 38,503,211.00 |
-- Toronto | 73,933 PC | 83,177,378.00 CAD |
-- Paris | 82,001 PC | 77,760,700.37 EUR |