Technical data
Chapter 9 Creating Hierarchies
Parent Child
Member Override User
Function
USA
TX
<RED_HERRING>
USA
IL
(leaf)
Assume that a SALES data cube exists in the cube collection, and the three dimensions of this example
are attached to this data cube.
Re
ad the instructions carefully before analyzing the following table; the table describes two methods that the
an
alytic calculation engine can use to calculate hierarchies.
• When you analyze only the first four columns of the table (ignore the fifth column), the basic analytic model
does not contain any cube dimension overrides.
The first column displays the row numbers. The second, third, and fourth columns list the members of
each of the three dimensions.
• When you analyze all five rows of the table, the basic analytic model does contain cube dimension overrides.
The first column displays the row numbers. The second, third, and fourth columns list the members of each
of the three dimensions. The fifth column-where it applies-lists the override that the analytic calculation
engine uses to calculate the row.
For example, if the developer applies the SALES_CUBE_OVERRIDE cube dimension override to the
TRANS_DATE dimension as it is attached to the SALES data cube, the Cube Dimension Override User
Function column indicates where the override is applied.
Italicized values in the table indicate aggregate members. A row may contain more than one aggregate
member. If a row contains one or more aggregate members, the table denotes the winning aggregate member
along with the method that the analytic calculation engine uses to calculate the member. If a row does not
contain any aggregate members, the analytic calculation engine uses the data cube’s rule to calculate values.
Row
ACCT Dimension
Member
Priority 1
TRANS_DATE
Dimension
Members
Priority 2
DEPT Dimension
Members
Priority 3
Cube
Dimension
Override User
Function
1
Winning aggregate:
100
Use member override
user function:
USA <SALES_
ACCT_SUM>
Q1 USA NA
2
Winning aggregate:
100
Use member override
user function:
USA <SALES_
ACCT_SUM>
Q1 CA NA
Copyright © 1988-2007, Oracl e. All rights reserved. 93