Page 112 - DCAP606_BUSINESS_INTELLIGENCE

Unit 7: Creating Cube

Notes
Find out the defaults used by the create cube wizard.
Task

Self Assessment

Fill in the blanks:

1. A Cube is the main object of a .............................. where the majority of fine tuning,
calculations, aggregation design etc.
2. Right-click the Cube folder and select “New Cube”, and it will invoke the .........................

7.2 Concept of Cube

A cube is a multidimensional structure that contains information for analytical purposes; the
main constituents of a cube are dimensions and measures. Dimensions define the structure of
the cube, and measures provide aggregated numerical values of interest to the end user. A cell,
in the cube, is defined by the intersection of dimension members and contains the aggregated
values of the measures at that specific intersection.

A cube provides a single place where all related data, for analysis, is stored.
Did u know?
A cube is composed of:
Dimensions

Measures and Measure Groups
Partitions
Perspectives
Hierarchies

Actions
Key Performance Indicators (KPI)
Calculations
Translations

7.3 Adding Measure and Measure Groups to a Cube

You can use the Define New Measures page to create new measures for a cube that is being
created without using a data source.
To get familiar with all related operations of a Cube, read the following context:

If you select measures from template Options it will displays the measures from the cube
template to include in the cube.
To include a specific measure from the template, select the check box for that measure.

To include all measures from the template in the cube, select the check box in the header.
Use Measure Name to lists the measures that are available in the template.

LOVELY PROFESSIONAL UNIVERSITY 107