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
43
Note. No winning
aggregate. Because
this row does not
contain any aggregates,
use the data cube’s rule
for calculating values.
111
Jan NY
NA
44
Note. No winning
aggregate. Because
this row does not
contain any aggregates,
use the data cube’s rule
for calculating values.
111
Jan TX
NA
45 111
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
46
Note. No winning
aggregate. Because
this row does not
contain any aggregates,
use the data cube’s rule
for calculating values.
111
Feb
CA NA
47
Note. No winning
aggregate. Because
this row does not
contain any aggregates,
use the data cube’s rule
for calculating values.
111
Feb
NY
NA
Copyright © 1988-2007, Oracl e. All rights reserved. 103