Skip to content

Category Archives: large dimensions

Ways of calculating Running Count to import data into Multi-Line models

I’ve nicked the term “Multi-Line” model out from some cognos best practices presentations. Never known it was called that way ) Multi-Line is only way to go when you have a potentially huge dimension only a tiny bit of which should be available to end-user at a time. Like employee planning, whole dimension of 10k [...]

Posted 01 February 2008 † ykud § bi § BI&CPM § cognos § ep § ep cookbook § open source ‡ Comments (0) ° Tagged: , , ,

More on Contrib APs.

It’s more a list of demands for Cognos We need allocation cubes with an elist. There is no other way round the idea of dynamic Contributor applications. Dynamic as Analyst ones — by changing allocations in cube, you change data flow. Ain’t that analytic? What if we use footage as driver for lease costs? Or, [...]

Posted 11 October 2006 † ykud § cognos § contributor-only ‡ Comments (4) ° Tagged: , ,

Tip of day

@AddLocalPreselection macro allows you to “slice” all cubes in macro on dlist selection. You can choose one month and all commands in macro will be applied only to this month slices. By setting up an input variable for this macro, you make choice dynamic. Macro starts, you choose month and them all commands are applied [...]

Posted 29 August 2006 † ykud § cognos § tips ‡ 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 § ep cookbook ‡ Comments (2) ° Tagged: , ,