## Question

Are screenshots required? I care about traffic and am rather lazy.

Skip to content
## Question

## D-list formated elements and calculations.

## EP. Dimension order. Small example.

## Multiple Currencies in EP

Are screenshots required? I care about traffic and am rather lazy.

Some more common mistakes, which are always happening. Dlist formatted items can be used as virtual dimesions, but they allways have Force-to-Zero Option. Therefore That’s very good, what IID1 + IID2 mean, anyway? (even if it’s IID29 :-)) But when you link 2 cubes and want to transfer a calculated value, you link a source…

Common question: how dimension order affects calculations? Because calculation order appears only in cross-dim calculations, we can create following sample cube (x’s are inputed): c d c/d a x1 x2 x1/x2 b x3 x4 x3/x4 a+b x1+x3 x2+x4 ??? The ??? marks the trouble spot. It can be: 1) (x1+x3)/(x2+x4) 2) (x1/x2)+(x3/x4) Calculation sequence is…

Problem arises when we need multiple currency input and conversion. Let us have 2 currencies: dollars and euros. Common example — sales cube. Formulas are naive. Euro Dollar Qty Price Gross Profit Price is weighted on Qty as usual Question: Can data be inputed into multiple currencies at…