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