Monthly Archives: January 2014

SSAS Trending KPI

Posted on January 27, 2014 by MikeDavisSQL

KPI’s (Key Performance Indicators) in Analysis Services are a great way to show visually if a measure is trending in right direction based on previous levels. If you want to show a measure has increased or decreased since last month, … Continue reading →

Posted in SSAS, Syndication | Tagged | Leave a comment

SSAS Reporting Action with Date Parameters

Posted on January 20, 2014 by MikeDavisSQL

Reporting Actions in Analysis Services allows you to open a report in Reporting Services. Most of the time users want to pass in some parameters to the report so it shows the relevant data. If the parameter name matches the … Continue reading →

Posted in SSAS, SSRS, Syndication | Tagged , | Leave a comment

SSAS – Using the Euro or Pound currency Symbol in a measure Format String

Posted on January 13, 2014 by MikeDavisSQL

If you have a set of measures and some of them are US dollars, some are Euros, and some are UK Pounds, you want to format them correctly in SSAS. First you will need to know the ASCII command to … Continue reading →

Posted in SSAS, Syndication | Tagged | 1 Comment

SSAS Dynamic KPI from a table

Posted on January 6, 2014 by MikeDavisSQL

KPI’s (Key Performance Indicators) in Analysis Services are a great way to show visually if a measure is above or below a goal. Managing the goal numbers can be a headache because they made need to be updated often. By … Continue reading →

Posted in SSAS, Syndication | Tagged | Leave a comment