Report Portal

Using SSAS MDX Calculation Color Expressions

Analysis Services calculations are great for storing formulas that your users need to see on a regular basis.  They also have another little feature that adds just a little more wow when your end users browse the cube. 

By building a color expression on a calculation you can change either the fore color or background color of a measure value.  Here you can write an MDX expression that will change the font or background color of a cell when a user selects the calculation.  A very basic example is below. 

Read more...

 

Tags: design, mdx

 

2007-2015 VidasSoft Systems Inc.