| yongli 2006-01-26, 4:58 pm |
| What about using custom rollup and iif() function to branch calculation for X
and Y.
"graemevn" wrote:
> Assume the following parent-child dimension:
>
> ALL_XY
> |
> --X
> ------Leafmember1
> ------Leafmember2
> |
> --Y
> ------Leafmember3
> ------Leafmember4
> ------Leafmember5
>
> To sum to the [ALL_XY]-level, we can use the following MDX formula:
> [X] + [Y] in the 'All Member Formula' section.
>
> No problem here...
>
> ------
>
> B U T:
>
> 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)) --- Equation 1, say
>
> *Note: by default the formula X = (Leafmember1 + Leafmember2) always
> applies due to the hierarchy. I don't want this formula. I want to
> apply equation 1 and equation 2 (below).
>
> and say
>
> Y=(Leafmember3 + (0.5*Leafmember4) + (0.2*Leafmember5)) --- Equation 2,
> say
>
> =====
> 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)?
> 3. Can it be done in the 'Custom Rollup Formula'? I thought that any
> formula here will apply to X and Y. I want distinct rollup formulas for
> both X and Y. So, can I even hope to get equation 1 and 2 done in the
> dimension editor?
>
>
> Any help in this regard will be greatly appreciated.
>
>
|