Author Archives: MikeDavisSQL

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

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

Posted in SSRS, Syndication | Tagged | Leave a comment

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 the specified SQL statement.”. Possible failure reasons: Problems with the query, “ResultSet” property not set correctly, parameters not set … Continue reading

Posted in SSIS, Syndication | Tagged | Leave a comment

SSRS Map Layers Parameter

With the new Map control in SSRS 2008 R2 there are three different map types, Road, Aerial, and Hybrid. If you want to allow your users to change the map type you would think you could map a parameter to … Continue reading

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

SSIS Pivot on bad data

The pivot transform in SSIS is already a pain to use. When you have bad data it makes it even worse. In this blog I am going to show how to handle bad data when using the pivot transform. You … Continue reading

Posted in SSIS, Syndication | Tagged | Leave a comment

SSRS Nulls in a matrix

In a recent SSIS class one my students ask me, if you are reporting off a table and using it in a matrix, does the matrix show null rows. The answer is yes. Here is an example table and the … Continue reading

Posted in SSRS | Tagged | Leave a comment

Missing Foreign Keys in SSAS DSV

When creating report models you might run into bad database designs where the tables have no foreign keys and/or no primary keys. This can be resolved in the report model DSV. I have created two tables, one with first names, … Continue reading

Posted in SSAS | Tagged | Leave a comment

SSIS Records on the Same Row – kind of like pivot

If you have two or more records on the same row, and need to write each record on its own row in a destination, you have two choices. You can do this in series or parallel in a single data … Continue reading

Posted in SSIS, Syndication | Tagged | 1 Comment