Technical data

ManualsBrandsSimplicity ManualsDo-It-Yourself tools4564

101

102

103

104

105

106

107

108

109

110

Chapter 9 Creating Hierarchies

DEPT field

Data Type: Number

SOMEDATE field

Data type: Date

NUM_SALES field

Data Type: Number

PRICE_PER_UNIT field

Data Type: Number

101 2004–01–01 1 10

102 2004–01–02 2 14

103 2004–01–01 4 15

201 2004–01–01 8 20

202 2004–02–01 16 23

You

want the analytic model to:

• Calculate aggregates for the NUM_SALES field.

• Save the aggregates for the NUM_SALES field.

• Establish hierarchies for the DEPT and SOMEDATE dimensions.

• Refrain from calculating aggregates for the PRICE_PER_UNIT field.

• Save all aggregates for the DEPT dimension.

• Refrain from saving aggregates for the SOMEDATE dimension.

Creating the Ag gregates

To f

ulfill the requirements of the analytic model, perform these steps:

1. Create these dimensions:

• DEPARTMENT

•DATE

2. Create these data cubes:

• SALES

• PRICE_PER_UNIT

3. Enable the Calculate Aggregates field for the SALES data cube, because you want to calculate

aggregates for this data cube.

4. Ensure tha t the Calculate Aggregates field is disabled for the PRICE_PER_UNIT data cube, because

you do n ot want to calculate aggregates for this data cube.

5. Create a cube collection called SALES.

6. Select MainData as the main record for the SALES cube collection.

7. Map the data cubes and dimensions within the SA LES cube collection to fields in the main record.

This table provides the mappings:

Data Cube or Dimension to Map Field in Main Record

DEPARTMENT dimension DEPARTMENT field

Data type: Num ber