Phone: 303-899-4000  A division of Decentrix Inc.
BIAnalytix Tip Summary: Media Calculated Measure Performance

OLAP (On-Line Analytical Processing) technology is designed for very fast presentation of the accumulations of Measures such as revenue or avail capacity. But real world media reports have, alongside the usual Measures, columns with many Calculated Measures that have filters and conditions defining the inclusion of measure values such as revenue or capacity for selected dimension members such as promos or exceptions. These can be expressed as CASE or IIF statements to conditionally select and accumulate the filtered values. Understandably, these conditional calculations have the potential to be processing intensive resulting in the users experiencing analysis delays. Obviously, any delay in user analysis presentation is counterproductive in an efficient BI implementation.

In almost all cases, these filters can be alternatively implemented by directly specifying cells in the cube before the cube aggregations are performed. This approach is a superior solution that retains the very fast presentation of aggregations by implementing the complex real world filters on business data such as revenue and break capacity through direct cube cell assignments.

BIAnalytix
is an advanced Data Warehouse and Business intelligence system that provides calculated measures defined for efficient and fast presentation of the aggregated values.

BIAnalytix Tips-Archive
Ask our Experts
Subscribe
Schedule a webcast
About BIAnalytix
About Decentrix
© Copyright 2001-2008, Decentrix Inc. All rights reserved.
Decentrix Inc. 1200 17th Street, Suite 500, Denver, Colorado, 80202 Phone: 303-899-4000

Privacy Policy | Decentrix Website Solution & Analytic Tools | DishOnTheWeb.com by Decentrix, Dish Network Retailer Solutions
Afftraq Affiliate Sales Tracking Solution | HotDesk, Superior Websites for Small to Medium Size Business

Home Why Business Intelligence Why Data Warehouse Products BIanalytix Toolset Media/Advertising Data Warehouse Best of Breed Products KPIs Dashboards and Portal BIanalytix Features Consulting Industries Advertising Agency Cable MSO Cable Network Radio Satellite Operator Television News FAQ Contact Company