Here is my situation


Dimension :

Charge,Calander,.......

Charge : All,Yes, NO, UNK

Calendar : Year,Qtr,Month


Fact for the year 2005,Q3,09

Chare : All

Mile V AMT, D Amt,........

10 123.22 234.46
20 128.33 452.00
30 423.34 322.02
40 762.22 456.32


I want Mile same for whatever Charge(All,Yes,No,UNK)

If user select either All,Yes,No,UNK Mile should be same, only if they
change Month mile can change for this dimension otherwise
if should display Month level value.

For all other dimension mile can change accordingly

Can anyone help me


Thanks
Kalyan

You could use calculated measure and 'hard code' the charge level. Something
like

sum([Measures].[Mile], [charge].[All])


MC


"Kalyan" <Kalyan (AT) discussions (DOT) microsoft.com> wrote

I am new to MDX, I tried like this

SUM([Chargable Account].[All], [Measures].[SMiles])

I got error msg. like this

Unable to update calculated memberm,
formula error - Syntax error token is not valid
SUM([Chargable Account].[All], [Measures].[SMiles])



I tried like this
WITH MEMBER
[Measures].[Miles_S]
AS
'SUM([Chargable Account].[All], [Measures].[SMiles])'


same error,

Can you help me?

Thanks
Kalyan


"MC" wrote:

You need to put a name of the (All) member, not the level. So lets say you
called the (all) memeber something like 'All accounts'. You would write

SUM([Chargable Account].[All accounts], [Measures].[SMiles])

The point is, you need to specify member, not level. Offcourse, it would
perhaps be better to write

SUM([Chargable Account].[All].members, [Measures].[SMiles])


MC

"Kalyan" <Kalyan (AT) discussions (DOT) microsoft.com> wrote

MC

Thanks for timely help, it works fine and another question is

Can I call calculated member inside another calculated member?

thanks
kalyan

"MC" wrote:

Yes, you just need to carefull to generate them in a correct order.
Obviously, you cant call a member you didnt define at that point .


MC

"Kalyan" <Kalyan (AT) discussions (DOT) microsoft.com> wrote