MDX Statement that was executed:
SELECT
NON EMPTY [Measures].MEMBERS 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:
Cost in statistics currency (SAP DEMO) | Number of Document Items (SAP DEMO) | Number of documents (SAP DEMO) | Gross weight in kg (SAP DEMO) | Net Value in Statistics Currency (SAP DEMO) | Net weight in kg (SAP DEMO) | Open order quantity in base unit (SAP DEMO) | Open order net value in statistic currency (SAP DEMO) | Quantity in base units (SAP DEMO) | Volume in cubic decimeters (SAP DEMO) | ||
All Sales organization | 504,231,497.05 * | 8,315.000 | 4,025.000 | 14,763,830 KG | 600,275,774.38 * | 13,420,845 KG | 16,487 PC | 55,697,308.00 * | 558,507 PC | 124,993,503 CDM | |
-- Frankfurt | Germany | 19,059,594.32 EUR | 420.000 | 150.000 | 601,493 KG | 22,690,011.31 EUR | 546,813 KG | 674 PC | 1,561,050.00 EUR | 21,437 PC | 5,153,370 CDM |
-- Berlin | Germany | 29,128,427.23 EUR | 504.000 | 228.000 | 965,549 KG | 34,676,733.62 EUR | 877,773 KG | 840 PC | 1,368,050.00 EUR | 43,612 PC | 6,759,240 CDM |
-- Munich | Germany | 56,792,116.85 EUR | 1,182.000 | 486.000 | 1,661,488 KG | 67,609,696.31 EUR | 1,510,436 KG | 2,866 PC | 8,487,800.00 EUR | 56,084 PC | 14,911,050 CDM |
-- Hamburg | Germany | 17,030,564.28 EUR | 264.000 | 150.000 | 478,256 KG | 20,274,491.93 EUR | 434,781 KG | 479 PC | 1,072,800.00 EUR | 22,449 PC | 3,425,490 CDM |
-- London | England | £ 38,503,211.00 | 1,122.000 | 516.000 | 1,807,232 KG | £ 45,837,155.00 | 1,642,935 KG | 1,421 PC | £ 1,246,899.00 | 72,781 PC | 14,465,370 CDM |
-- Birmingham | England | £ 24,446,569.00 | 678.000 | 312.000 | 1,126,592 KG | £ 29,103,061.00 | 1,024,174 KG | 1,002 PC | £ 696,696.00 | 47,300 PC | 11,626,230 CDM |
-- Paris | France | 77,760,700.37 EUR | 954.000 | 618.000 | 2,595,536 KG | 92,572,276.21 EUR | 2,359,578 KG | 3,933 PC | 33,888,000.00 EUR | 82,001 PC | 23,930,655 CDM |
-- New York | USA | $ 65,216,274.00 | 822.000 | 438.000 | 1,839,101 KG | $ 77,638,457.00 | 1,671,090 KG | 1,515 PC | $ 1,837,725.00 | 69,538 PC | 15,078,210 CDM |
-- San Francisco | USA | $ 22,293,811.00 | 324.000 | 198.000 | 610,005 KG | $ 26,540,269.00 | 554,550 KG | 750 PC | $ 940,278.00 | 22,416 PC | 5,144,040 CDM |
-- Toronto | Canada | 83,177,378.00 CAD | 930.000 | 528.000 | 1,655,828 KG | 99,020,683.00 CAD | 1,505,302 KG | 2,031 PC | 2,824,470.00 CAD | 73,933 PC | 11,626,488 CDM |
-- Vancouver | Canada | 66,419,790.00 CAD | 984.000 | 360.000 | 1,282,385 KG | 79,071,185.00 CAD | 1,165,807 KG | 843 PC | 1,233,540.00 CAD | 44,397 PC | 11,342,040 CDM |
-- Sydney | Australia | 4,403,061.00 AUD | 131.000 | 41.000 | 140,365 KG | 5,241,755.00 AUD | 127,606 KG | 135 PC | 540,000.00 AUD | 2,559 PC | 1,531,320 CDM |