I have a hierarchy of reseller , which is parent child



Like Res1 is parent of Res2
Res2 is parent of Res4 and Res5.

We have measure of Sellingamount

Suppose Res1 sales one item at 100$ to Res2
now Res2 sales same item to Res4 at 120$


when we browse the cube it shows sale of 220$.
But same item is sold twice , so there is no meaning of showing sum of
it.

What I need to show is sum of sale of Res1 as 100 instead of 220.
How can I do it?

in parent-child dimension you can assign a value to each member at each
level instead-of aggregating the child values.
your database should contain the value for each member:
Res1 100$
Res2 120$
Res4 100$

activate the member with data option of the dimension (which mean that
you'll provide values for parent members)

does this helps you?

<sqlprobs (AT) gmail (DOT) com> wrote