Aggregating Data Within the Cube
The last step of creating your OLAP cube is running through the Aggregation Design Wizard and determining how best to represent and aggregate the data for your users. This is the point at which you must determine the optimal aggregation levels and storage method for these aggregations (MOLAP, HOLAP, or ROLAP) for the optimal performance of queries against the cube.
You double-click the cube entry in the Solution Explorer (Comp Sales2014.cube) to bring up the cube designer for your newly created cube. Then you click the Partitions tab to see the current partition for Comp Sales. Figure 46.39 shows the default storage mode is MOLAP and that there is no Aggregation Design for this cube yet. Just to the lower right ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
