Microsoft Excel Cube Formula Secrets Revealed HD

Microsoft Excel Cube Formulas linked to an OLAP cube can be used to automate almost any kind of reporting and yet few people have mastered how to use them. This video not only shows you how to create dynamic cube formulas (dependant on adjacent cell contents) it also demonstrates in a few simple steps how to mix pivot table filters and slicers with cube formulas to create a whole new level of flexible reporting. This demonstration is based on a Locii Insight demo cube which is built with MS SQL Analysis Services 2008 containing approximately 10 million records.