Cooking With CUBEs

Microsoft sneaked a couple of ne As we should all know by now, PowerPivot provides Excel with a powerful way to harness data from one or more sources, and to do further analysis on that data within familiar pivot tables. Furthermore, because PowerPivot is creating an in-memory cube of the data, it is possible to build an analysis using CUBE formulae. I have blogged a couple of times about CUBE formulae, in Cycling Through The Fog and in Cracking The Code. In Excel, as with any development, you want your solution to be as flexible and dynamic as possible. This … Continue reading Cooking With CUBEs