Database Reference
In-Depth Information
In the previous screenshot, you can see how to invoke a custom action from within
Excel 2013. When this is done, an additional sheet will open in Excel showing the
first 1000 rows of the values building up the aggregation.
If this type of functionality is important to you, then your only choice today is the mul-
tidimensional model.
Aggregations
The tabular model is built to be an in-memory model that has the ability to quickly
scan and process billion of rows, and aggregate the values quickly when the user
queries it. The multidimensional model, on the other hand, is a file-based model that
needs aggregations to work well. This means that the developer defines pre-calcu-
lated values that will be used by the engine when users query the model. Adding
Search WWH ::
Custom Search