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