Tag Archives: dlists

D-list formated elements and calculations.

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 [...]

Multiple Currencies in EP

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 [...]