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.

© Copyright 2011, 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 Website Solution Collaboration NetAnalytix e-Commerce Technology Overview Architecture Quickcentrix Quickcentrix Integration Kit Consulting Web Analytics Consulting e-Commerce Consulting Business Intelligence Analytics Decentrix Process Online Marketing Site Visitors Search Engines Register With Yahoo Register With Google Search Engine Ranking Becoming Visible Online Collecting Prospect Lists Checklist Target Market Tours Website Solution Tour Collaboration Tour NetAnalytix Tour BIAnalytix Tour Clients News Press Releases e-Newsletters Contact Support Sales Company Vision Management Team Careers