Technical data

Creating Hierarchies Chapter 9
Fully Qualified Member Name DEPART ME NT TREE_DATE NUM_SALES
GBL.LAT AM
CAL2004.JAN
LAT AM JAN 8
GBL. LAT AM
CAL2004.FEB
LAT AM
FEB
16
• If you select to persist all aggregates of the DEPT_TREE dimension and to persist none of the
aggregates of the DATE_TREE dimension on the Dimensions tab of the cube collection’s properties,
the following rows are persisted in the aggregate record:
Note. Italicized values are the actual persisted aggregate members. Zero (0) values in this table not
persisted. The Fully Qualified Member Name field is not a database value.
Fully Qualified Me mber Name DEPARTMENT TREE_DATE NUM_SALES
GBL
CAL2004.JAN. 200 4–0 1–0 1
GBL 2004–01–01 13
GBL
CAL2004.JAN.2 004 –01 –02
GBL 2004–01–02 2
GBL
CAL2004.FEB.2004–02–0 1
GBL 2004–02–01 16
GBL.US
CAL2004.JAN.2 004 –01 –01
US 2004–01–01
5
GBL.US
CAL2004.JAN.2 004 –01 –02
US 2004–01–02 2
GBL.US
CAL2004.FEB.2004–02–0 1
US 2004–02–01 0
GBL.LAT AM
CAL2004.JAN.2 004 –01 –02
LAT AM 2004–0 1–0 2 8
GBL.LAT AM
CAL2004.JAN.2 004 –01 –02
LAT AM 2004–0 1–0 2 0
GBL.LAT AM
2004–02–01
LAT AM 2004–0 2–0 1 16
90 Copyright © 1988-2007, Oracl e. All rights reserved.