Page 113 - DCAP606_BUSINESS_INTELLIGENCE

Business Intelligence

Notes To rename a measure, click on that measure and type a new name.
Use Measure Group to lists the measure group for the measure.
To change the measure group, click on the measure group, and then either enter a new
measure group or select an existing measure group from the list.

To add a measure group to a cube

1. In Solution Explorer, right-click the cube, and then click View Designer.
2. In Cube Designer, click the Cube Structure tab.
3. Either click the New Measure Group button or right-click anywhere in the Measures pane
and then click New Measure Group.
4. In New Measure Group, click the table from the data source view that you want to use as
the new measure group, and then click OK.

To remove a measure group from a cube

1. In Solution Explorer, right-click the cube, and then click View Designer.

2. In Cube Designer, click the Cube Structure tab.
3. In the Measures pane, click the measure group that you want to remove.
4. Either click the Delete button or right-click the measure group and then click Delete.
5. In the Delete Objects dialog box, review the object to be deleted, and then click OK.

Self Assessment

Fill in the blanks:
3. A .......................... is a multidimensional structure that contains information for analytical
purposes; the main constituents of a cube are dimensions and measures.

4. A cube provides a single place where all related data, for analysis, is ..........................
5. We use .......................... to lists the measures that are available in the template.

6. We use .......................... to lists the measure group for the measure.

7.4 Calculated Members

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. Calculated member can also be defined
as assessees.

!

Caution Only the definitions for calculated members are retained; values are calculated in
memory when required to answer a query.
Calculated members enable you to add members and measures to a cube without expanding its
size. Although calculated members must be based on data (such as constituents) that currently
lives in the cube, you can create complex expressions by combining this data with arithmetic

108 LOVELY PROFESSIONAL UNIVERSITY