Articles

Analysis And Reporting Analysis And Reporting Applications OLAP OLAP Cubes OLAP Software Data Visualization Data Visualization Software Data Cubes Data Processing Data Analysis Data Analysis Software Data Reporting Business Intelligence Business Intelligence Tools Analytic Applications Analyzing Sales Trends Knowledge Management Knowledge Management Software Business Performance Management Corporate Performance Management Ad Hoc Reporting From SQL Server Ad Hoc Reports Microsoft SQL Server Microsoft OLAP MS OLAP Cubes Multidimensional Data Analysis Corporate Data Studying Customer Buying Patterns Decision Support Enterprise Reporting Executive Information Systems Analysis Server Analysis Server Cube Data Analyst Tools Data Mining Data Mining Tools Point And Click Analysis SQL Server Cubes SQL Server OLAP More Resources About Analysis And Reporting

Analysis And Reporting

MS OLAP Cubes

by Jacey Harmon

A data cube is a multi-dimensional database that stores, analyzes and reports large amounts of data. Cubes are used to identify business trends that signal opportunities or problems. The multidimensional aspect of cubes refers to the storage of multiple data elements. A cube can be used to track and compare the number of sales and type of product sold by each salesman. The cube can then be used to track how salesmen are performing, what they are selling, and when.

MS Excel pivot table is an example of a data cube that can be used in Excel. Data cubes can be accessed through the Internet using applications such as MS Active X controls or active server pages. By using MS query a user can save results from a query and later open the files through Excel and publish the results to the Web.

Storing Data Cubes

There are three basic ways to store data cubes: MOLAP, ROLAP, and HOLAP. MOLAP, or "Multidimensional Online Analytical Programming," stores the aggregates and base level data in individual files. This requires more disk space but is a faster method of retrieving the data.

ROLAP "Relational Online Analytical Processing," stores the aggregates in tables next to the base level data. This requires less disk space than MOLAP storage but sacrifices a little bit of speed. Hybrid Online Analytical Processing, HOLAP, is a cross between MOLAP and ROLAP. Hybrid OLAP saves the aggregates into a MOLAP file while storing the base level data in a database.

Get all Data Analysis articles via