I have a cube that have 5 dimemsions and a couple of measures. One of the
measures is QTY. One of the dimensions is dim_type. dim_type has 4 members:
A, B, C, D.

I would like to create a calculated measure QTY_AB that only aggragetes base
on A and B for dim_type. Other dimensios are as normal. for example,
A: 30
B: 20
C: 6
D: 7
At all_dim_type level, QTY gives me 63 (30+20+6+7) but QTY_AB gives me only
50 (30+20). I couldn't come up with the correct syntax for QTY_AB. Help,
please.

How about something like:

Sum({[dim_type.[A], [dim_type.[b]},
[Measures].[QTY])


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***