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
35
Winning aggregate:
120
Use the <ACCT_
DIM_DEFAULT_
FORMULA>
dimension o verride
user function because a
member override user
function d oes not exist
for this mem ber:
Feb
NY
NA
36
Winning aggregate:
120
Use the <ACCT_
DIM_DEFAULT_
FORMULA>
dimension o verride
user function because a
member override user
function d oes not exist
for this mem ber:
Feb
TX
NA
37 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 for
this dim ension.
USA <SALES_
CUBE_
OVERRIDE>
38 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 for
this dim ension.
CA <SALES_
CUBE_
OVERRIDE>
Copyright © 1988-2007, Oracl e. All rights reserved. 101