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

Hold and breakback

Started by Cognos_World, 20 Jan 2012 04:41:43 PM

Previous topic - Next topic

Cognos_World

Hello Cognoise Forum

A cube has 4 dimensions.
Version
Sales Data
Departments and
Time

I want to hold the Total for Departments and change some of the department values at the Year level . When I tried this the values are not getting split in other cells on pro rata basis.

Existing scenario:

E.g. Total = 100 (at Year level)
       Dept 1 = 25
       Dept 2 = 25
       Dept 3 = 25
       Dept 4 = 25

Expected Scenerio:
At Total Year column.

Total Dept= 100 ( Hold)
Dept 1 = 25 (value changed manually)
Dept 2 = 35 (value changed manually)
Dept 3 = 40 (Breakback by Analyst)
Dept 4 = 5  (breakback by Analyst)   

Currently, when I do this, there is no change in the values. Any ideas why this may not be working? Appreciate someone sharing there thoughts on this.

Thank you for your time.







lav4you

#1
Kindly make sure that the break-back department nodes  total or others do not have any weighted average or calculation on other dimension.