Tag Archives: MDX

Filtering data with MDX

One of the key activities when analysing data is to filter.   This is especially true when the data source is a data mart. This post is about filtering with MDX in preparation for reporting with SSRS. The query editor … Continue reading

Posted in Analysis Services | Tagged , | Leave a comment

MDX functions – Except & Filter – intermediate level

I’ve been getting to grips with MDX functions to aid analysis and reporting.  The recent functions I’ve come across are EXCEPT & FILTER. In this post we’ll look at an example where these functions can come in handy. If this … Continue reading

Posted in Analysis Services | Tagged , , | Leave a comment

Top N Calculation

When you create a Pivot Table based on an Analysis Services cube you are able to create sets based on an MDX expression. In this post I will talk you through how to build a Top 10 set to order … Continue reading

Posted in Analysis Services, Power Pivot | Tagged , | Leave a comment

Querying Analysis Services with VBA

Many people use excel pivot tables as a means of retrieving data from an Analysis Services OLAP cube. This is okay for most situations where you want a quick way of retrieving data for analytical purposes. However, there is a different way to do … Continue reading

Posted in Analysis Services | Tagged , , | 5 Comments