Skip to content

Category Archives: ep cookbook

Analyst Breack-back tips. Multiple hierarchies.

Thing you rarely run at. What will happen if you trigger a breack-back on two hierarchies at the same time, with some elements belonging to both of hierarchies? Via d-link? Got to it on practice, when 5 or 6 profiles were mashing up, and the multiple breack-backs to be triggered by a link. Possible variants [...]

Posted 06 July 2006 † ykud § cognos ‡ Comments (0) ° Tagged: , , ,

Large product list handling. Sales planning.

Big dimensions are ep’s doom for sure. But nevertheless we need them to get going. Problem statement: A regional sales planning model to be created. 10k products(with product subgroups), spread among number of regions selling some subsets of product list (each subset is relatively small, about 2k els). Regions are contributors. Oh yes, cognos innovation [...]

Posted 27 June 2006 † ykud § cognos § large dimensions ‡ Comments (2) ° Tagged: , ,

Question

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

Posted 23 June 2006 † ykud § ‡ Comments (0) °

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

Posted 23 June 2006 † ykud § cognos ‡ Comments (0) ° Tagged: , ,

EP. Dimension order. Small example.

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

Posted 20 June 2006 † ykud § ‡ Comments (1) °

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

Posted 20 June 2006 † ykud § cognos § currency ‡ Comments (1) ° Tagged: , , ,