Hi

Need help
following expression give

[Experience].CURRENTMEMBER.LEVEL.NAME

name of level, is there any way to get value on this level.


Thanks
kalyan

Hi Kalyan,

Can you clarify what you mean by "get value on this level"? If you have
an example, that would help. You can get all members at a level, if
that's what you're looking for:

[Experience].CURRENTMEMBER.LEVEL.Memmbers


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

Thanks Deepak,

Here is my situation,

I have following measure

QTY_YES, QTY_NO, QTY_UNK and


Dimension : Chargable (All),Y , N or U



IF Chargable

I want to know

(All) (QTY_YES+QTY_NO+QTY_UNK)/1000000

Y QTY_YES/1000000
N QTY_NO/1000000
U QTY_UNK/1000000



Can you help me how to create calculated measure for above scenario ?


Thanks in advance

Kalyan


"Deepak Puri" wrote:

Kalyan,

It sounds like QTY_YES, QTY_NO, QTY_UNK are 3 separate cube measures. In
that case, it might be simpler to have just one measure like QTY, from
which these 3 could be derived. Anyway, you could combine these
measures, using case (if you're using AS 2005) or iif, in a calculated
measure:

[Measures].[QTY_YES],
iif([Chargable].CurrentMember is [Chargable].[N],
[Measures].[QTY_NO],
iif([Chargable].CurrentMember is [Chargable].[u],
[Measures].[QTY_UNK], [Measures].[QTY_YES] +
[Measures].[QTY_NO] + [Measures].[QTY_UNK])))
/ 1000000

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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