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
70
Note. No winning
aggregate. Because
this row does not
contain any aggregates,
use the data cu be’s rule
for calculating values.
121
Feb
CA NA
71
Note. No winning
aggregate. Because
this row does not
contain any aggregates,
use the data cu be’s rule
for calculating values.
121
Feb
NY
NA
72
Note. No winning
aggregate. Because
this row does not
contain any aggregates,
use the data cu be’s rule
for calculating values.
121
Feb
TX
NA
The analytic calculation engine used this logic to determine which c ell of the row it finally used to calculate
the aggregate:
• Aggregation for row 25:
The analytic calculation engine used the 120 value from the TRANS_DATE dimension because this
dimension was the only dimension that contained an aggregate member. Understand that if either of the
two other dimensions contained an aggregate member, the analytic calculation engine would still select the
120 value because the TRANS_DATE dimension is first in priority. The analytic calculation engine used
the <ACCT_DIM_DEFAULT_FORMULA> dimension override because neither a cube dimension user
function nor a member override user function existed for this member.
• Aggregation for row 37:
The analytic calculation engine used the Q1 value from the TRANS_DATE dimension because this was
the only dimension that contained an aggregate member. The analytic calculation engine used the default
sum aggregation because neither a member override user function existed for this member nor a dimension
override user function existed for this dimension.
• Aggregation for row 41:
The analytic calculation engine used the USA value from the DEPT dimension because this was
the only dimension that contained a n aggregate member. The analytic calculation engine used
<DEPT_DIM_DEFAULT_FORMULA> because neither a cube dimension user function nor a member
override user function existed for this member.
108 Copyright © 1988-2007, Oracl e. All rights reserved.