COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: soulghard on 20 Jun 2011 10:37:44 AM

Title: Consolidation in control cube
Post by: soulghard on 20 Jun 2011 10:37:44 AM
Hi everyone,

I have in my dimension "mydim" a numeric attribute "attr" for elements.

For consolidated level I have 0 instead of a consolidation, which I consider a normal behaviour.
Lev0-attr = 0
Lev0-elem0-attr = 2
Lev0-elem0-attr = 4
...


In my case I would like to make an average calcul for consolidated elements for this attribute. Is that possible ? And how can I do that ? With which kind of rules ?
Lev0-attr = 3 with the previous exemple.

Thanks in advance for your response
Title: Re: Consolidation in control cube
Post by: OLAPBPMguy on 20 Jun 2011 08:09:02 PM
Numeric atributes are really "strings in disguise". Numeric attributes behave just like string attributes with data entry possible at any level and numeric rules do not work in attribute cubes.  To implement natural conslidation of child numeric values or an average or a count or whatever the best method is to create a parallel 2D standard cube to hold the numeric attribute values and any further calculations then simply create a rule in the attribute cube to pull the values accross for all levels.