Let's say I have a hierarchy as follows:

ALLMember
- Leafmember1
- Leafmember2
- Leafmember3
- Leafmember4
- Leafmember5

To sum to the [ALL Member]-level, we can use the following MDX formula:
[X] + [Y].

No problem here...



But, how will I sum X and Y if I want to say the following (in other words
both X and Y sums to certain weights of their leaf members):
X = Leafmember1 + (0.67*Leafmember2)

and say

Y= Leafmember3 + (0.5*Leafmember4) + (0.2*Leafmember5)

THUS:
=====
1. How can I have different (weighted) rollup formulas for X and Y?
2. Where can I do it in the MS-OLAP dimension editor (for a certain dimension)
?


Any help in this regard will be greatly appreciated.

Hi

Where do the weight factors come from?
The more quick running solution would be to place the factors direct into
fact table und create masure.
The second choice is to create a dimension attribute, thereafter create
calculated measure. This solution will be definitive slower as the first.


Vladimir Chtepa

"graemevn" <u17960@uwe> schrieb im Newsbeitrag news:5ac537dc254e1 (AT) uwe (DOT) ..