BIAnalytix Tip Summary: Benefits of Perspectives in OLAP Cubes

The Media Business Intelligence system utilizes Microsoft SQL Server Analysis Services which has many options for simplifying data access. The ability to create perspectives in the OLAP (Online Analytical Processing) cube is one of the benefits of implementing data cubes in SSAS.

An OLAP cube can have the contents of a full data warehouse contained in many dimensions and measures. For specific users this rich structure can be very overwhelming and complex to filter, making data retrieval and reporting a daunting task.


Perspectives can be used to logically split up the cube into smaller, more manageable views of the data making it much less intimidating to the business users. Perspectives do not physically break up the data, but control the visibility of the objects in the cube. Dimensions, Attributes, Hierarchies, Measure groups, Measures, Key Performance Indicators, Calculations and Actions are all objects that can be defined in a perspective. Perspectives are not meant to enforce data security; their purpose is to create a better user experience through simplification of complex structures.

BIAnalytix is an advanced Data Warehouse and Business intelligence system that utilizes Microsoft SQL Server Analysis Services, which allows users to implement Perspectives in the OLAP cube to simplify the filtering of data.

© 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