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