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
8
Winning aggregate:
100
Use member override
user function:
USA <SALES_
ACCT_SUM>
Jan TX
NA
9
Winning aggregate:
100
Use member override
user function:
USA <SALES_
ACCT_SUM>
Feb
USA NA
10
Winning aggregate:
100
Use member override
user function:
USA <SALES_
ACCT_SUM>
Feb
CA NA
11
Winning aggregate:
100
Use member override
user function:
USA <SALES_
ACCT_SUM>
Feb
NY
NA
12
Winning aggregate:
100
Use member override
user function:
USA <SALES_
ACCT_SUM>
Feb
TX
NA
Copyright © 1988-2007, Oracl e. All rights reserved. 95