Author Archives: MikeDavisSQL

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

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

Posted in SSIS, Syndication | Tagged | 17 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

Faster Video Learning

If you are watching video to learn things like T-SQL or Business intelligence, you can spend a lot of time watching these videos. There is a way to speed up your learning. Just speed up the video. In Windows Media … Continue reading

Posted in Business Intelligence, Community | Tagged | Leave a comment

Execute SSIS Packages with a Macro in BIDS

When running SSIS packages in BIDS it is common to click on the green arrow at the top of BIDS to run a package. One problem that can occur when using this button is the deployment of project and the … Continue reading

Posted in SSIS, Syndication | Tagged | 1 Comment

Environment Variables in SSIS Packages and Configuration Tables

Configuration tables are a best practice in just about any SSIS environment. They make it easy to update multiple packages from a single change. But one of the issues with configuration tables is the location of the server is different … Continue reading

Posted in SSIS, Syndication | Tagged | 4 Comments

Custom Navigation controls in SharePoint 2010

There are several ways to create a custom navigation control in SharePoint. In the below image you can see the left navigation is hidden. This is done with the use of a master page and some custom CSS. Now you … Continue reading

Posted in SharePoint, Syndication | Tagged | Leave a comment

Custom Coding in SQL Report Services

Reporting Services 2008 is a very powerful tool for creating reports. It contains many different tools and even allows you to place complex expressions on reports in every field. Even with all of these tools there are some instances where … Continue reading

Posted in SSRS, Syndication | Tagged | Leave a comment