Pass Summit 2011
SQL Rally
Category Archives: Syndication
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
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
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
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
SSRS Interactive Sorting a Matrix
Sorting a matrix report can be done interactively. To perform interactive sorting, your report you will need a cell to click on to perform the action. In the image below you can see a basic matrix report with State as … Continue reading
SSIS For Loop Skip Files
When running a For Each Loop through a set of files, sometimes you will have specific files that you do not want to load. For example, I have a set of files named: Abc.txtMno.txtRts.txtWln.txtXyz.txt If I want to skip the … Continue reading
Setting up Security on sub sites in SharePoint 2010
A lot of companies have several departments and want to limit the sub sites users can view. For example, the IT department should only see the IT sub site, but the HR department may need to be able to see … Continue reading
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
SSRS – Self Referencing Reports or Drill through to same report
When looking at a report and wanting to drill through to get more detail, we often create two reports for this. This can be accomplished by just one report by creating a self-referencing action that links to the same report. … Continue reading
Reverse or Mirrored Bar Chart in SSRS
There are some pretty charts out there and most of them can be done in Reporting Services. There is one type of chart I had someone ask for that is not natively built in to SSRS. But with a little … Continue reading
MikeDavisSQL 