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
53 112
Jan
Winning aggreg a te:
USA
Use the dime nsio n
override user
function <DEPT_
DIM_DEFAULT_
FORMULA> because
a member override user
function does not exist
for this member.
NA
54
Note. No winning
aggregate. Because
this row does not
contain any aggregates,
use the data cube’s rule
for calculating values.
112
Jan
CA NA
55
Note. No winning
aggregate. Because
this row does not
contain any aggregates,
use the data cube’s rule
for calculating values.
112
Jan NY
NA
56
No winning aggregate.
Because this row
does not contain any
aggregates, use the
data cube’s rule for
calculating values.
112
Jan TX
NA
57
112
Feb Winning aggregate:
USA
Use the dime nsio n
override user
function <DEPT_
DIM_DEFAULT_
FORMULA> because
a member override user
function does not exist
for this member.
NA
Copyright © 1988-2007, Oracl e. All rights reserved. 105