April 2009
Beginner
448 pages
14h 1m
English
After you develop a measure group, you can use the Aggregation Design Wizard to design aggregations. A greater number of aggregations provides faster query response time, but uses more disk space and takes longer to process. So, when you use the Aggregation Design Wizard, you will be asked to restrict the number of aggregations that are designed by limiting the estimated amount of storage space the aggregations will use, by setting a limit for the performance gain the aggregations will provide, or by manually stopping the wizard while it is designing aggregations. The wizard, assuming that all queries are equally likely, will design the combination of aggregations that provide the best tradeoff between increased ...