Technical data

Chapter 9 Creating Hierarchies
• DEPT_TREE
Parents Children
(no parent —root)
GBL
GBL US
GBL LAT AM
US 101
US 102
US 103
LAT AM 201
LAT AM 202
• DATE_TREE
Parents Children
(no parent — root)
CAL2004
CAL2004 JAN
CAL2004
FEB
JAN 2004–01–01
JAN 2004–01–02
FEB
2004–02–01
11. Consider these scenarios for default sum aggregation:
• If you select to persist all aggregates of both dimensions on the Dimensions tab of the cube
collection’s properties, the following rows are persiste d in the aggregate r ecord:
Note. Italicized values are the actual persisted aggregate members. Zero (0) values in this table are
not persisted. The Fully Qualified Member Name field is not a database value.
Fully Qualified Member Name DEPARTMENT TREE_DATE NUM_SALES
GBL
CAL2004.JA N . 2004–01–01
GBL 2004–01–01 13
GBL
CAL2004.JA N .200 4–01–02
GBL 2004–01–02 2
GBL
CAL2004.FEB.2004–02–01
GBL 2004–02–01 16
Copyright © 1988-2007, Oracl e. All rights reserved. 87