Tag Archives: ssas

SSRS – Creating Drill Through reports with MDX

If you are reporting from a Cube in SSRS and you want to drill through to another report you can set up actions just like any other drill through except one small change. The parameter you pass to the drill … Continue reading

Posted in mdx, SSAS, Syndication | Tagged , | 2 Comments

SSAS Trending KPI

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

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

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

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

SSAS – Setting Attributes as Properties for Excel

When a user is browsing your cube with excel they may not understand how to slice the data and end up using things like “first name” as a hierarchy to slice the data. This does not make for good analysis, … Continue reading

Posted in SSAS, Syndication | Tagged | 1 Comment

SSAS – Process everything

This is just  short blog with a quick tip for those that don’t know. When working with SSAS it is sometimes necessary to process every dimension before continuing with development. This can be accomplished with a couple of clicks on … Continue reading

Posted in SSAS | Tagged | Leave a comment