Category Archives: Analysis Services

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

Don’t forget about SSRS

Do you know about the bundled reporting tool that comes with SQL Server? SSRS (SQL Server Reporting Services). Well, I’ve been using this lately more than Power Pivot. The reason? Quite simply, the data being queried is already present in … 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 , , | 7 Comments