MDX Statement that was executed:
SELECT
NON EMPTY {[Measures].[0D_COSTVALS], [Measures].[0D_QUANT_B]} ON AXIS(0),
NON EMPTY [0D_SALE_ORG].MEMBERS ON AXIS(1)
FROM [$0D_SD_C03]
CELL PROPERTIES CELL_ORDINAL, VALUE, FORMATTED_VALUE
Result set:
Cost in statistics currency (SAP DEMO) | Quantity in base units (SAP DEMO) | |
All Sales organization | 2,523,553,093.38 * | 2,331,425.550 * |
-- Frankfurt | 296,697,862.06 * | 393,276.000 * |
-- Berlin | 104,233,721.42 * | 173,501 PC |
-- Munich | 203,137,588.87 * | 274,717.000 * |
-- Hamburg | 127,395,065.07 * | 189,361 PC |
-- London | 317,416,631.08 * | 226,996.000 * |
-- Birmingham | 174,762,889.74 * | 227,152.000 * |
-- Paris | 218,918,946.76 * | 173,562 PC |
-- 1594 | $ 87,221,527.61 | 35,414 PC |
-- 1596 | $ 103,580,032.19 | 42,348 PC |
-- New York | $ 225,064,663.72 | 151,024 PC |
-- San Francisco | $ 244,669,518.55 | 102,496 PC |
-- 1616 | $ 37,297,219.65 | 12,756 PC |
-- 1618 | $ 60,165,142.78 | 40,833 PC |
-- 1620 | $ 15,604,277.88 | 5,726 PC |
-- Toronto | 182,003,710.00 CAD | 185,637 PC |
-- Vancouver | 82,488,380.00 CAD | 69,086 PC |
-- Sydney | 42,895,916.00 AUD | 27,541 PC |
-- # | 0 | 0 |
MDX Statement that was executed:
WITH MEMBER
[Measures].IBICalculatedMemberImpl_000001 AS
'(([Measures].[0D_COSTVALS])) / (([Measures].[0D_QUANT_B]))'
SELECT
NON EMPTY {[Measures].[0D_COSTVALS], [Measures].[0D_QUANT_B], [Measures].IBICalculatedMemberImpl_000001} ON AXIS(0),
NON EMPTY [0D_SALE_ORG].MEMBERS ON AXIS(1)
FROM [$0D_SD_C03]
CELL PROPERTIES CELL_ORDINAL, VALUE, FORMATTED_VALUE
Result set:
Cost in statistics currency (SAP DEMO) | Quantity in base units (SAP DEMO) | IBICalculatedMemberImpl_000001 | |
All Sales organization | 2,523,553,093.38 * | 2,331,425.550 * | 1,082.408 * * |
-- Frankfurt | 296,697,862.06 * | 393,276.000 * | 754.427 * * |
-- Berlin | 104,233,721.42 * | 173,501 PC | 600.77 * PC |
-- Munich | 203,137,588.87 * | 274,717.000 * | 739.443 * * |
-- Hamburg | 127,395,065.07 * | 189,361 PC | 672.76 * PC |
-- London | 317,416,631.08 * | 226,996.000 * | 1,398.336 * * |
-- Birmingham | 174,762,889.74 * | 227,152.000 * | 769.365 * * |
-- Paris | 218,918,946.76 * | 173,562 PC | 1,261.33 * PC |
-- 1594 | $ 87,221,527.61 | 35,414 PC | $ 2,462.91 PC |
-- 1596 | $ 103,580,032.19 | 42,348 PC | $ 2,445.93 PC |
-- New York | $ 225,064,663.72 | 151,024 PC | $ 1,490.26 PC |
-- San Francisco | $ 244,669,518.55 | 102,496 PC | $ 2,387.11 PC |
-- 1616 | $ 37,297,219.65 | 12,756 PC | $ 2,923.90 PC |
-- 1618 | $ 60,165,142.78 | 40,833 PC | $ 1,473.44 PC |
-- 1620 | $ 15,604,277.88 | 5,726 PC | $ 2,725.16 PC |
-- Toronto | 182,003,710.00 CAD | 185,637 PC | 980.43 CAD PC |
-- Vancouver | 82,488,380.00 CAD | 69,086 PC | 1,194.00 CAD PC |
-- Sydney | 42,895,916.00 AUD | 27,541 PC | 1,557.53 AUD PC |
-- # | 0 | 0 | 0 |