MDX Statement that was executed:
SELECT {[Measures].[0D_QUANT_B],[Measures].[0D_COSTVALS]} ON COLUMNS, NON EMPTY [0D_SALE_ORG].MEMBERS ON ROWS FROM [$0D_SD_C03] WHERE ([0D_VTYPE].[010],[0D_VERSION].[000],[0D_DIV].[7])
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 |