# Palo.eweight

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

• # Palo.eweight

Hi,
I need to change the weight of an element when it's consolidated at a higher level:

Global consolidate element
child A
child B
child C
little child CA
little child CB
little child CC

Trying to be clear enough, I want that when I display child C, it's displayed all the little children. But if I want to display the Global consolidate element. The little child CB must be apart the sum.

I thought to this kind of rule:
['Global consolidate element']=c: (PALO.EWEIGHT("database","Cube",!'dimension',"little child CB";)=0)

but the final "=0" isn't good

Many thanks for any help (even big )

The post was edited 3 times, last by j_o_hann ().

• Hi,

It is not possible to dynamically change the weight of an element in an hierrachy.
What you could do is define the tree like this:

Element: Weight:
Global consolidate element
--child A 1
--child B 1
--child C 1
-----little child CA 1
-----little child CB 1
-----little child CC 1
--little child CB -1

In this case when you select child C it will contain the sum of little child CA, little child CB and little child CC.
When you select the Global consolidate element however, it will contain the sum of child A, child B and child C minus little child CB. So the value for little child CB is eliminated from the total.

Michel

The post was edited 1 time, last by Michel ().

• Thanks Michel,

It's a great solution

but actually it's impossible to create two elements (thx Michel) with the same name.
So I think that I will create a new dimension call:
little child CB pounded

to link little child CB and little child pounded, I will create a rule
['little child CB pounded']=['little child CB']

It works....Many thanks Michel

Johann

The post was edited 2 times, last by j_o_hann ().

• Hi Johann,

I'm not quite sure what you mean with 2 dimensions.
For all certainty: it is possible to have the same element occur in more than 1 place in the hierarchy, with different weights in the different consolidations. So it should be no problem to create the example dimension - see attached picture: dimension definition on the left, resulting hierarchy on the right side.

Regards,

Michel
Images
• elim_example.jpg

101.2 kB, 630×302, viewed 1,376 times
• Your solution is the good one

thanks for the picture