Technical data

Creating Hierarchies Chapter 9
Row
ACCT Dimension
Member
Priority 1
TRANS_DATE
Dimension
Members
Priority 2
DEPT Dimension
Members
Priority 3
Cube
Dimension
Override User
Function
39 111
Winning aggregate:
Q1
Use default sum
aggregation because
neither a member
override user
function exists for
this member, nor a
dimension override
user function exists fo r
this dim e nsion.
NY
<SALES_
CUBE_
OVERRIDE>
40 111
Winning aggregate:
Q1
Use default sum
aggregation because
neither a member
override user
function exists for
this member, nor a
dimension override
user function exists fo r
this dim e nsion.
TX
<SALES_
CUBE_
OVERRIDE>
41 111
Jan
Winning aggregate:
USA
Use the dimension
override user
function <DEPT_
DIM_DEFAULT_
FORMULA> because
amemberoverrideuser
function does n ot exist
for this m em ber.
NA
42
Note. No winning
aggregate. Because
this row does not
contain any aggregates,
use the data cu be’s rule
for calculating values.
111
Jan
CA NA
102 Copyright © 1988-2007, Oracl e. All rights reserved.