…brew your own Business Intelligence

Archive for January 2014

Filtering a Pivot Table by a Large Dimension

A common issue I see on the MSDN forums and at clients is how to reduce the number of members available in a filter to only those with data in the pivot table. This question often originates from users wanting to filter the results of a pivot table by a […]

Read more

Bus Matrix Presentation Follow Up Q&A

On 1/14/2014, I presented Bus Matrix…the foundation of your Dimensional Data Model via the Free Training on the T’s offered by PragmaticWorks. If you weren’t able to attend the live session, you can watch the recording here. This presentation touched on a lot of complex concepts (dimensional modeling, conformed dimensions, […]

Read more

MDX: Slicer Override

In MDX, the WHERE-clause is commonly referred to as the “slicer”. This is because the criteria placed in this clause is used to “slice the cube”. Any query scoped named sets or members will be created/calculated within the context specified in the WHERE-clause. For example, the query below will return […]

Read more

MDX: Order of Named Sets and Calculated Members

Just before the end of 2013, I started a new project doing some heavy MDX development. During a recent code-review session with the rest of the team, one of the developers brought up an issue with one of the queries where a named set was referencing another named set before the […]

Read more

Problems with the Self-Service Paradigm

There’s no denying the substantial benefits of self-service BI – arguably one of the most important paradigm shifts in the past 5 years. And I can’t help but give Microsoft the nod for a job well done on that front. The whole suite of “power tools” (e.g. Power Pivot, Power View, […]

Read more