|
Home > Archive > MS SQL Server OLAP > August 2005 > Urgent - Non aggregated level of a Dimension
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Urgent - Non aggregated level of a Dimension
|
|
| mansoorak77@gmail.com 2005-08-27, 11:23 am |
| 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@gmail.com> wrote in message
news:1125155911.463092.85360@g44g2000cwa.googlegroups.com...
>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
>
|
|
|
|
|