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

Continue reading →

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

Continue reading →

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

Continue reading →