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...

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...

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...

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...

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...

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...

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...

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...

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...

SSIS Execute SQL error – No disconnected record set is available

If you get the error in SSIS that says:

…failed with the following error: “No disconnected record set is available for...