Technical data

Contents
Definition of a Data Cube..........................................................................................31
Input Data Cubes...................................................................................................32
Calculation D
ata Cubes....................................................................................
........33
Association Data Cubes...........................................................................................33
Virtual Data Cubes.. ...............................................................................................35
Understandi
ng the Relationship Between Field Definition Attributes and Data Cube Formats......
........38
Creating Input Data Cubes.................................................................................... ........38
Creating Calculation Data Cubes....................... .. .................................. .. .. ............. ........39
Creating As
sociation Data Cubes............................................................................
........39
Creating Virtual Data Cubes.................................................................................. ........40
Defining Data Cube Properties............................................................................... ........40
Defining G
eneral Data Cube Properties.................................................................
........40
Selecting Aggregate Functions for Attached Dimensions.....................................................42
Auditing Data Cubes at Design Time........................................................................ ........43
Understa
nding Causes and Inputs.......................................................................
........44
Understanding Effects.................. .. ....................................... .. ................................44
Displaying Causes and Inputs....................................................................................45
Displayi
ng Effects...........................................................................................
........45
Using the Causes and Effects Tool...............................................................................46
Chapter 6
Creating Dimensions................................................................................. ........47
Unders
tanding Dimensions...................................................................................
........47
Creating a New Dimension.................................................................................... ........48
Defining Dimension Properties....... ........... ........... ......... .. ......... ........... ........... ........ ........48
Attac
hing a Dimension to a Data Cube......................................................................
........50
Changing the Order of Dimensions in the Part Browser.................................................. ........51
Chapter 7
Creating Cube Collections.......................................................................... ........53
Unde
rstanding Cube Collections.............................................................................
........53
Types of Cube Collections.................................................................................... ........54
Read/Write Cube Collections......... ................ ................ .. ................ ..........................54
Inte
rmediate/Calculation Cube Collections..............................................................
........55
Presentation Cube Collections....................................................................................56
Example: Creating Two Cube Collections.......................................................................56
Cre
ating Cube Collections....................................................................................
........57
Defining Cube Collection Properties......................................................................... ........58
Copyright © 1988-2007, Oracl e. All rights reserved. vii