Monthly Archives: December 2013

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

Posted in SSRS, Syndication | Tagged | 1 Comment

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

Posted in SSIS, Syndication | Tagged | 4 Comments

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

Posted in SharePoint, 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

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

Posted in SSRS, Syndication | Tagged | 4 Comments