Page 107 - DCAP606_BUSINESS_INTELLIGENCE

Business Intelligence Deepak Mehta,Lovely Professional University

Notes Unit 7: Creating Cube

CONTENTS
Objectives
Introduction

7.1 Wizard to Create Cube
7.1.1 Explanation
7.2 Concept of Cube

7.3 Adding Measure and Measure Groups to a Cube
7.4 Calculated Members
7.5 Deploying and Browsing a Cube
7.6 Summary
7.7 Keywords

7.8 Review Questions
7.9 Further Readings

Objectives

After studying this unit, you will be able to:

Discuss the Wizard to Create Cube
Recall the Concept of Cube
Explain the Adding Measure and Measure Groups to a Cube
Demonstrate Calculated Members

Identify Deploying and Browsing a Cube
Introduction

A data cube is a three (or more) dimensional array of values, commonly used to describe a time
series of image data. An OLAP cube is an array of data understood in terms of its 0 or more
dimensions. Benefit of building a cube to store your data is that you can centralize the business
rules for calculations that you can’t easily store in a relational data mart. The structure of the
cube makes it much easier to write queries to compare data year over year and also you gain the
ability to transparently manage aggregated data in the cube. In this chapter, you will learn
about creating a cube using Wizard. It also discusses adding measure and measure groups to
cube. Finally, calculated measures and deploying and browsing of cube are discussed in the unit.

7.1 Wizard to Create Cube

Use the Cube Wizard to create a cube rapidly and effortlessly. When you create the cube, you can
add living dimensions or create new dimensions that structure the cube. You can also create
dimensions separately, using the Dimension Wizard, and then add them to a cube.

102 LOVELY PROFESSIONAL UNIVERSITY