Page 118 - DCAP606_BUSINESS_INTELLIGENCE

Unit 7: Creating Cube

A cube is a multidimensional structure that contains information for analytical purposes; Notes
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 calculated member is a dimension member whose worth is calculated at run time using
a sign that you specify when you define the calculated member.

Browsing a deployed cube helps you understand the modifications that you should make
to improve the functionality of the cube.
Perspective and Language options are available on the toolbar of the Browser tab.

The Browser tab includes two panes to the right of the metadata pane: the upper pane is
the filter pane, and the lower pane is the data pane.

7.7 Keywords

Cube: A Cube is the main object of a SSAS solution where the majority of fine tuning, calculations,
aggregation design etc.
Cube Wizard: Use this wizard to create a cube. The wizard helps you select the data source, fact
table, measures, and dimensions for a new cube.

7.8 Review Questions

1. What is the Cube Wizard?
2. Give the explanation for creating cube.

3. “A Cube is the main object of a SSAS solution”. Do you agree? Discuss.
4. Write down the concept of cube.
5. Discuss about adding measure and measure groups to a cube.

6. What are the steps for removing a measure group from a cube?
7. “Calculated member can also be defined as assesses”. Elaborate.

8. Give explanation for individual panes in cube designer.
Answers: Self Assessment

1. SSAS solution 2. Cube Wizard
3. Cube 4. Stored

5. Measure Name 6. Measure Group
7. True 8. True

9. Cube data, Dimension data 10. Filter pane, data pane

LOVELY PROFESSIONAL UNIVERSITY 113