Browsing Analysis Services OLAP Cubes with Excel - Microsoft Business Intelligence Tools for Excel Analysts - page 256

Figure 13-11: Excel gives you the option of converting your filter fields.
After a second or two, the cells that used to house a PivotTable are now homes for cube formulas.
Note that, as shown in Figure 13-12, any styles you may have applied are removed. The formula bar
tips you off that these cells are now cube formulas: the formulas start with =CUBEVALUE .
Figure 13-12: The formula bar shows these cells are now a series of cube formulas.
So why is this capability useful? Well, now that the values you see are no longer part of a PivotTable
object, you can insert rows and columns, add your own calculations, combine the data with other
external data, and modify the report in all sorts of ways by simply moving the formulas around.
Adding Calculations to Your OLAP PivotTables
In previous versions of Excel, OLAP PivotTables were limited in that you couldn't build your own cal-
culations with the OLAP data. This means you could not add that extra layer of analysis like you could
with the calculated fields and calculated items functionality found in standard PivotTables.
Excel 2013 changes that with the introduction of the new OLAP tools: calculated measures and calculated
members. With these two new tools, you can add your own analysis by building your own calculations.
In this section you explore how to build your own calculated measures and calculated members.