BIAnalytix Tip Summary: OLAP Aggregation Design

OLAP aggregation designs are a crucial element of any business intelligence system. Aggregation designs are the key to making user queries and reports perform at their peak. Maintaining aggregation design is a vital task to keeping a BI system running efficiently. Aggregation design and maintenance can be a bit of a science because too many aggregations can impact processing times as much as too few aggregations can hinder query performance.

Media aggregation design can be tricky especially if designing aggregations manually. An alternative solution that can help is to design usage based aggregations. This method can help you design aggregations that will satisfy common but slow MDX queries. Another important consideration when designing aggregations starts with the fundamental dimension design.

Aggregations can be flexible or rigid based on the attribute relationships of the dimensions they are built from. It takes only one flexible dimension attribute relationship to make the entire aggregation flexible. When a process update on a dimension is performed and data changes, all flexible aggregations are dropped from the partitions. By understanding this concept, developers can help the aggregation maintenance process by creating rigid attribute relationships when appropriate. With a basic understanding of how aggregations can be designed and maintained, the last step is to create a suitable processing solution that takes flexible aggregations into consideration.

BIAnalytix is an enterprise class Media specific BI system built on a strong foundation of OLAP aggregation knowledge to provide high performance BI Solutions.

© Copyright 2012, Decentrix Inc. All rights reserved.
Decentrix Inc. 1200 17th Street, Suite 200, Denver, Colorado, 80202 Phone: 303-899-4000  
 
 Decentrix Website Solution & Collaborative Intranet Tools   |   DishOnTheWeb.com by Decentrix, Dish Network Retailer Solutions
Afftraq Affiliate Sales Tracking Solution   |  HotDesk, Superior Website & Intranets for Small to Medium Size Business

Home Products Solutions Consulting Education Blog News Contact Company Webcast BIAnalytix Media Data Warehouse CloudMBI - BIAnalytix in the cloud MDM Mapper Mobility Apps BIAnalytix Media Data Warehouse BIAnalytix Architecture BIAnalytix Features Microsoft BI Toolset CloudMBI Data Warehouse CloudMBI Architecture CloudMBI Features Windows Azure Platform Advertising Agency Television Radio Cable Network Cable MSO IPTV Satellite Operator Publishing Power of KPIs Case Studies White Papers Educational Videos FAQs Press Releases Interviews Management Team Careers Management Team