Data Cube Design using SQL Server | ||
Al-Rafidain University College For Sciences | ||
Article 1, Volume 0, Issue 20, January 2017, Pages 18-33 | ||
Author | ||
Moaid A.Fadhil | ||
Abstract | ||
When we try to extract information from a database, we need tools to help us find what's relevant and what's important and to explore different scenarios. A report, whether printed on paper or viewed on-screen, is at best a two-dimensional representation of data, a table using columns and rows. That's sufficient when we have only two factors to consider, but in the real world we need more powerful tools. On-Line Analytical Processing (OLAP) is a category of software technology that enables analysts, managers and executives to gain insight into data through fast, consistent, interactive access to a wide variety of possible views of information that has been transformed from raw data to reflect the real dimensionality of the enterprise as understood by the user. An OLAP system can be modeled by a three-level architecture that consists of a Query Client, a Data Cube engine and a Data Warehouse or Relational DB. In this paper we introduce a Client Graphical Application Interface to Design & Create Local Cube from relational database and to connect to SQL Analysis Service OLAP Cube Server to make complex queries, switch from summary to detail data, and filter or slice data into meaningful subsets. | ||
Keywords | ||
SQL | ||
Statistics Article View: 148 PDF Download: 40 |