Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Archives: September 2013

MDX YTD Calculation Issus

If you are using the templates for MDX calculation built into SSAS 2008 you might run into some strange issues. In the image below you can see the calculation is working for all years except for 2008.

My first thought was data issue. After querying the table and finding no…

Read more

0 comments, 205 reads

Posted in Mike Davis SQL on 30 September 2013

MDX Scope with an If Then statement

The scope statement in MDX is great for applying calculations to a certain area of a cube, also called a subcube. Dustin Ryan wrote a great article on the scope statement here. The issue I am going to cover will be using the scope statement when you only want to…

Read more

0 comments, 182 reads

Posted in Mike Davis SQL on 23 September 2013

Loop Through Excel Files in SSIS

You can loop through excel files using SSIS. This will use the For Each Loop container and a data flow task.

First Create a variable named strExcelfile as a string variable; you can leave the value blank.

Next, drag in a For Each Loop. Set it to For Each File,…

Read more

3 comments, 227 reads

Posted in Mike Davis SQL on 16 September 2013

Junk Dimensions with no Loading Needed

When you are working with dimensional modeling there are some situations where several dimensional attributes don’t make since to be in any other dimension. When this occurs you can combine them into one dimension call a Junk Dimension.

In this example you will see a person type dimension that only…

Read more

0 comments, 391 reads

Posted in Mike Davis SQL on 9 September 2013

Handling Large Many to Many bridge tables

In some scenarios you will need to create a many to many relationship in your cube in SSAS. One of the problems that arise from many to many bridge tables are the size of these tables. In this example we have a fact table that contains the history of a…

Read more

0 comments, 859 reads

Posted in Mike Davis SQL on 2 September 2013