Monthly Archives: December 2008

EXISTING and query context

There had been some posts discussing the multi select problems in MDX. If, for example, you have a calculated measure using CURRENTMEMBER, the measure might not be computable when selecting a set as a WHERE condition. You can take a … Continue reading

Posted in Allgemein | Leave a comment

Formatting actual and goal for a KPI

Being able to specify the preferred format for measures and calculated measures in SSAS is a great feature since you just do the definition once and clients can leverage this central definition. But for a KPI expression (value, goal, status, … Continue reading

Posted in Allgemein | Leave a comment