Post reply

Dynamic Color Expressions in Calculated Members

  • October 14, 2011 at 8:18 am

    #249413

    Hi all,

    I want to create a colour expression on a Calculated Member that will apply one colour code if a dimension member equals X and another if it equals Y. e.g (please ignore my MDX syntax, just trying to explain what I mean!:

    iif([Call Type].[Call Direction].&[b]Outbound[/b],iif([measures].[%Connects] > 0.20, 16711680 /*Blue*/, 255 /*Red*/)), // over 20% Outbound then Blue

    iif([Call Type].[Call Direction].&[b]Inbound[/b],iif([measures].[%Connects] > 0.50, 16711680 /*Blue*/, 255 /*Red*/)) // over 50% Inbound then Blue

    Can this be done? If so how?!

    Cheers

    Neil

  • October 17, 2011 at 9:14 am

    #1395398

    This is a presentation issue, and is best done in the presentation layer. You don't mention what you are using for your presentation layer, so we can't give you further details.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

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

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