Post reply

Calculated member based on dimension value

  • September 8, 2010 at 7:53 am

    #146835

    Hi there.

    Basically I need to sum a value based on it's dimension member - and therefore 0 if it's not).

    I've tried the following but when browsing the cube the value returned is #VALUE!

    SUM(CASE WHEN [Account].[Source Type].&[TypeA] THEN [Measures].[MyValue] ELSE 0 END)

    Also to clarify, I wouldn't necessarily want this dimension attribute (Source Type) as a row value.

    Thanks,

    Dave

  • September 8, 2010 at 8:46 am

    #1217994

    OK, I'm a knob. All that needs to be done is.

    SUM([Account].[Source Type].&[TypeA], [Measures].[MyValue])

    Simple.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply