Consolidation in control cube

[soulghard]

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

[OLAPBPMguy]

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.