Category Archives: CUBE Functions

London Data Culture Day 2015

Posted on December 15, 2015 by wessexbob

At the recent London Data Culture Day, organised by Jen Stirrup, I gave a presentation on Excel Cube Functions, querying a SQL Server database uploaded into Power Pivot to provide the cube, focusing on using MDX to enhance the capability … Continue reading →

Posted in CUBE Functions, Excel, Pivots, Power BI, Power Pivot, Uncategorized | Tagged | Leave a comment

A CUBEMEMBERPROPERTY Equivalent With PowerPivot

Posted on February 16, 2014 by wessexbob

I was recently asked how to use the CUBEMEMBERPROPERTY function with a Power Pivot model, to get the Customer Name with a formula by using a unique code such as the Customer Code. I can’t say that I use this function … Continue reading →

Posted in CUBE Functions | Tagged , , , , , , | 12 Comments

MDX CUBEd

Posted on June 10, 2013 by wessexbob

I have posted a few times about Excel’s CUBE functions which are very useful for creating reports in a format and layout that pivot tables often just cannot achieve. They were useful when SSAS were the only cubes to work … Continue reading →

Posted in CUBE Functions | Tagged , , , , , , | Leave a comment