If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cognos 8.3 Measure Dimension - Disable roll up (i.e. no aggregation)

Started by htieK, 14 May 2009 08:13:19 AM

Previous topic - Next topic

htieK

Hi,

need some expert advise. Can we actually disable the roll up effect of a Cognos 8 measure dimension used in a DMR?

The reason why i need a non roll up measure dimension is as below.

i have a sales staff dimension as below:-
Division Mgr
Region Mgr
Area Mgr
Sales Rep

As our  business is such that the sales quota of sales rep need not necessary roll up to the aggregate total of his/her area mgr.
example, Area Mgr A has 2 sales rep A1 and A2. Sales quota for rep A1 could be 100,000 and 200,000 for A2. But Area Mgr A could actually has a quota of 250,000.

Hence, i design it such that each level of the sales staff dimension is linked to a SalesQuota measure dimension.
Division Mgr -> linked to a DivisionMgrQuota
Region Mgr  -> linked to a RegionMgrQuota
Area Mgr -> linked to a AreaMgrQuota
Sales Rep -> linked to a SalesRepQuota

Hence, when a division mgr views the DMR and chooses to use the sales rep quota (which is wrong), he should not see the Sales Rep Quota aggregated (simply just a blank value). Instead we intend to educate users to use the relevant quota. i.e. if division mgr, he shd use the quota for the division mgr measure dimension.

Hope this helps to clarify. Really at my wits end.

Thank u in advance