Tag Archives: ssas

Handling Large Many to Many bridge tables

Posted on September 2, 2013 by MikeDavisSQL

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

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

Per Member Per Month Per 1000 Calculations in MDX

Posted on May 20, 2013 by MikeDavisSQL

In a lot of industries there is a popular calculation called “Per Member Per Month Per 1000” calculation or the “Per Customer Per Month Per 1000” calculation. This is used to determine the level at which the company is rendering … Continue reading →

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

Studying and Learning Business Intelligence

Posted on October 2, 2012 by MikeDavisSQL

I have been doing interviews for Pragmatic works for the past few years and I have come across quite a few people who wanted to be hired as a senior BI consultant and their skills were just not up to … Continue reading →

Posted in Business Intelligence, PASS, Pragmatic Works, SSAS, SSIS, SSRS, Syndication, Training | Tagged , , | 2 Comments

How to hide Calculated Members in MDX SSAS

Posted on October 29, 2011 by MikeDavisSQL

With some calculated members in MDX it only makes sense to see the calculation if a certain Hierarchy is used. For example: Aggregate(YTD([Date].[Calendar].CurrentMember),[Internet Sales Amount]) This calculation only works in the Date.Calendar Hierarchy. I wanted to show the end users … Continue reading →

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

Creating your first Data Mining Structure and Model

Posted on September 30, 2011 by MikeDavisSQL

Data mining is a great way to help your company make decisions and predict future values. The Data Mining Algorithms built into SQL Server Analysis Services gives you this power. The Adventure works data base comes with views that are … Continue reading →

Posted in Data Mining, SSAS, Syndication | Tagged , | 1 Comment

SQL Saturday Orlando – Pre Con

Posted on September 7, 2011 by MikeDavisSQL

I’m very proud to announce that Pragmatic Works will be presenting a Business Intelligence Workshop pre-con for SQLSaturday #85 in Orlando on Friday September 23rd! In this session you’ll have not one, not two, not three but FOUR Pragmatic Works … Continue reading →

Posted in SQL Saturday, Training | Tagged , , , , | 2 Comments