I have supplier dimension with 3 levels

1st Level Name = Supplier Type
2nd Level Name = Supplier Name
3rd Level Name = Supplier Site.

With two Measures Quantity and Price.

I used custom rollup property on 3rd Level of supplier dimension to
avoid aggregation on these measure, but my client need aggregation on
2nd Level and 1st Level of quantity measure.

I already try custom rollup formula, custom member and custom member
option properties. All of them are not working.


How to solve this problem.

Waiting for reply & Thankx in advance of helping me


Mansoor

why you don't use a calculated measure instead of custom rollup?

let the current measures in place.
hide the price measure to the end user.
create a new calultaed measure like this:
iif(isleaf(supplier.currentmember), measures.HiddenPrice, null)

this return null if the user is not at the lowest level.


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