Technical data

Creating Hierarchies Chapter 9
Fully Qualified Member Name DEPART ME NT TREE_DATE NUM_SALES
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 –01
LAT AM 2004–01–01 8
GBL.LAT AM
CAL2004.JAN.2 004 –01 –02
LAT AM 2004–01–02 0
GBL.LAT AM
CAL2004.FEB.2004–02–0 1
LAT AM 2004–02–01 16
GBL.US.101
CAL2004
101 CAL2004 1
GBL.US.102
CAL2004
102 CAL2004 2
GBL.US.103
CAL2004
103 CAL2004 4
GBL LAT AM.201
CAL2004
201 CAL2004 8
GBL LAT AM.202
CAL2004
202 CAL2004 16
GBL.US.101
CAL2004.JAN
101 JAN 1
GBL.US.102
CAL2004.JAN
102 JAN 2
GBL.US.103
CAL2004.JAN
103 JAN 4
88 Copyright © 1988-2007, Oracl e. All rights reserved.