Technical data

Chapter 9 Creating Hierarchies
Row
ACCT Dimension
Member
Priority 1
TRANS_DATE
Dimension
Members
Priority 2
DEPT Dimension
Members
Priority 3
Cube
Dimension
Override User
Function
18
Winning aggregate:
110
Use member override
user function:
<DIRECTOR_ACCT_
SUM>
Jan
CA NA
19
Winning aggregate:
110
Use member override
user function:
<DIRECTOR_ACCT_
SUM>
Jan NY
NA
20
Winning aggregate:
110
Use member override
user function:
<DIRECTOR_ACCT_
SUM>
Jan TX
NA
21
Winning aggregate:
110
Use member override
user function:
<DIRECTOR_ACCT_
SUM>
Feb
USA NA
22
Winning aggregate:
110
Use member override
user function:
<DIRECTOR_ACCT_
SUM>
Feb
CA NA
Copyright © 1988-2007, Oracl e. All rights reserved. 97