Category Archives: SSAS

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

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 … Continue reading

Posted in mdx, SSAS, Syndication | Tagged , | Leave a comment

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 … Continue reading

Posted in mdx, SSAS, Syndication | Tagged , | 2 Comments

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 … Continue reading

Posted in Dim Model, SSAS, Syndication | Tagged | Leave a comment

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 … Continue reading

Posted in SSAS, SSIS, Syndication | Tagged , | 1 Comment

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

Posted in mdx, SSAS, Syndication | Tagged , | 1 Comment

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

Posted in SSAS, Syndication | Tagged | 1 Comment