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
65 121
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
66
Note. No winning
aggregate. Because
this row does not
contain any aggregates,
use the data cube’s rule
for calculating values.
121
Jan
CA NA
67
Note. No winning
aggregate. Because
this row does not
contain any aggregates,
use the data cube’s rule
for calculating values.
121
Jan NY
NA
68
Note. No winning
aggregate. Because
this row does not
contain any aggregates,
use the data cube’s rule
for calculating values.
121
Jan TX
NA
69 121
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. 107