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

Cracking The Code

Excel’s ability to run pivot tables against an OLAP cube in Analysis Services is a truly wondrous beast. The ease of use; volumes of data; the filtering; all of these provide a rich environment for users to easily inspect their data and get real information out. Add to this that Microsoft seem to believe that pivot tables are a winner and keep improving it, access to cubes and slicers being some of the latest significant changes, I can see no reason for all serious Excel users not to get to grips with this technology. In addition to all of this … Continue reading Cracking The Code

Cutting Edge BI

I went to the SQL Server 2008 R2 launch in London on 15th April 2010 (a while ago I know, but I have been away for a week :-)). I am not a SQL Server DBA or anything such, I went specifically for the BI sessions, PowerPivot and Reporting Services. I have to say that I enjoyed the day enormously, much more so than the Visual Studio 2010 launch the previous Monday (the Visual Studio day was informative, but a bit dry in comparison), but the reason for this post is to talk about the case study that was presented … Continue reading Cutting Edge BI

Cycling Through The Fog

Dynamic Analysis Excel 2007 provides the capability to have a pivot table connected to an OLAP cube. Furthermore, detailed analysis can be built by using various CUBE functions. One of the great things about Excel 2007 pivots and CUBE functions is that you can use a value from the pivot as a member value within a CUBE function. For instance, a CUBEVALUE might be getting the net gas sales for a particular company and period with CUBEVALUE(CubeName,                        “[Transaction Company].[Company Drilldown].&[17]”,                        “[Activity Date].[Date Drilldown].[Month].&[1]&[1]&[2009]”),                        “[Measures].[Gas_Amt_Net]”) If you also have a pivot that is filtering the company drilldown, the … Continue reading Cycling Through The Fog