Hello,

I am looking for help with the development of MDX
statements that work in the Scorecard Accelerator
application. This functionality exists when KPIs are
mapped back to Olap cubes. Rather than maintaining unique
measures or calculated measures in the Olap cube for each KPI, I would like to write an MDX statement in the Scorecard Accelerator that narrows down the measure value based on specified dimensions. The standard Select statement does not work. I was told at the WWPC that an IIF statement
must be used for this type of functionality.

Thanks of your help.