SSAS: Color Expressions for your calculated measures (calculations) in your cube

It’s a typical thing on a Friday…being a bit distracted sometimes.
I was designing a new cube and suddenly noticed the ‘Color Expressions’ thingy at the bottom while creating a new calculation in the Calculation-tab in Visual Studio:

SSAS-cube-calculated-measures-calculations-color-expressions-in-visual-studio

Haven’t tested it with different versions of Excel, but I think this is general client behavior if I may call it that:

SSAS-cube-calculated-measures-calculations-color-expressions-result-excel

Could be very useful I think, will discuss this option with the business….one day…next year…or probably not 🙂








Advertisements

One thought on “SSAS: Color Expressions for your calculated measures (calculations) in your cube

  1. This works in Excel, default settings are fine, can be changed by setting the pivottable options.
    I have used it and you can do very nice things. In the expression box you can write MDX, depending on the value setting a color for example. You can also use a scope statement, to change the color based on a dimension member attribute.
    SCOPE({[Dim].[Dim].&[1]});
    SCOPE([Measures].[Revenue]);
    Back_Color(THIS)=10222335;
    END SCOPE;
    END SCOPE;
    Endless possibilities!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s