Monthly Archives: July 2013

Custom Coding in SQL Report Services

Posted on July 29, 2013 by MikeDavisSQL

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

Creating a Rolling Date Range Named set in MDX

Posted on July 22, 2013 by MikeDavisSQL

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

Posted on July 15, 2013 by MikeDavisSQL

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

Report from a Cube in Reporting Services

Posted on July 8, 2013 by MikeDavisSQL

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 →

Posted in mdx, SSAS, SSRS, Syndication | Tagged , , | 3 Comments

Create a Named Set with all but one Member in MDX – SSAS

Posted on July 1, 2013 by MikeDavisSQL

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 →

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