Page 114 - DCAP606_BUSINESS_INTELLIGENCE

Unit 7: Creating Cube

operators, figures, and a variety of functions. Analysis Services constitutes a library of over 100 Notes
functions and allows you to list and use other function libraries.
Calculated members have a Format String property that controls the format of cell values
displayed to end users. This property is accessed in the properties pane of Cube Editor. The
Format String property accepts the same values as the Display Format property of measures.

The following image shows the Calculations tab of Cube Designer:
Figure 7.8: Calculations tab of Cube Designer

Source: http://i.msdn.microsoft.com/dynimg/IC574394.gif
Self Assessment

State whether the following statements are true or false:
7. Only the definitions for calculated members are retained; values are calculated in memory
when required to answer a query.

8. Calculated members have a Format String property that controls the format of cell values
displayed to end users.

7.5 Deploying and Browsing a Cube

Browsing a deployed cube helps you understand the modifications that you should make to
improve the functionality of the cube.

Example: You may have to define dimension member sort orders, delete unnecessary
dimension attributes, define new user hierarchies, modify existing user hierarchies, or configure
measure properties.

LOVELY PROFESSIONAL UNIVERSITY 109