Search
Post Calendar
December 2025 M T W T F S S 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 My Tweets
Tweets by MikeDavisSQLPass Summit 2011
SQL Rally
Meta
Author Archives: MikeDavisSQL
Creating a Rolling Date Range Named set in MDX
One Client I was working with wanted a named set that would give them the last 5 years. Of course this needed to be a rolling 5 years so it automatically moved the years up every January. To create this … Continue reading
SSAS Joining Facts at Different Granularities
In an SSAS cube you sometimes need to connect a dimension at a different granularity than other dimensions. For example, if you have budget measures and actual numbers. If you are trying to budget your expenses you budget at a … Continue reading
Report from a Cube in Reporting Services
Data warehousing has become a staple of businesses to help make business decisions. From these data warehouses you can develop an Analysis Services cube which allows for fast reporting. Creating reports in Reporting Services 2008 from a cube is very … Continue reading
Create a Named Set with all but one Member in MDX – SSAS
I was trying to create a Named set in SSAS 2008 using the MDX calculations. I wanted to include all of the members of a hierarchy except one of them. I started with trying to use the filter expression and … Continue reading
Comparing Previous Rows in SQL
I had a client recently that needed me to get the direction a student’s GPA was headed on a regular basis. To do this I needed to get the last GPA record on the table and the previous GPA. The … Continue reading
Pivoting weird data in SSIS – Sort of…
Sometimes we get data in some bad forms. For example look at the below table: The names and the amounts are comma separated in two different columns. Let’s imagine we need to get this data into a table like the … Continue reading
SSRS – Using a Parameter to make Dynamic Columns
Multiple value parameters are a common tools used in SSRS. You can use this tool to select which columns actually show on a report. You will need to create a multiple value parameter and place an expression on each column … Continue reading
AS400 Program from SSIS
If you need to call an AS 400 program from an SSIS package this can easily be accomplished with an Execute SQL Task. This can be made even easier with two variables and an expression too. The AS400 program QCMDEXC … Continue reading
Bulk Insert Task SSIS – Path Specified Cannot be Found or File Does Not Exist
When using the Bulk insert task in SSIS, you might encounter an error stating that The File Does Not Exist or The Path Specified Cannot be Found. This is usually due to the fact that the file must be on … Continue reading
Contract vs Permanent Employment
There is a lot of discussion online about the debate of what is better, being an independent contractor or a permanent employee. I have run into this myself. I am a permanent employee for Pragmatic Works, and I know the … Continue reading
Posted in Business Intelligence, Community, Training
Tagged business intelligence, consulting, training
2 Comments
MikeDavisSQL 