Applied dimensionality

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

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

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

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