Technical data

Creating Hierarchies Chapter 9
Creation of New Members at Runtime
PeopleSoft A n
alytic Calculation Engine can create new dimension members during runtime by using:
• Data from the main record.
• Application data that is added at runtime.
Relationship of Leaf Ranges to New Members
If you map a dim
ension to a tree that includes leaf ranges, PeopleSoft Analytic Calculation Engine adds a new
dimension mem
ber to the appropriate parent in the hierarchy when the application adds a new leaf that falls
within a leaf r
ange of the tree. Use the AddMember method to add n ew members to the dimension.
Note. PeopleSoft Analytic Calculation Engine ignores any new leaves that do not fall within the values of a
leaf range.
For example, suppose a tree contains a node called 2003Q1 that includes a leaf range of 2003-01-01 to
2003-03-31. During runtime, PeopleSoft Analytic Calculation Engine reads the main record data and
recognizes that the application has added 2003–02–04 as a new leaf that exists within the 2003Q1 leaf
range. PeopleSoft Analytic Calculation Engine creates the 2003–02–04 member and adds it as a child to the
2003Q1 member.
Understanding the Calculation of Aggregate Data
This section discusses:
•Dimensionor
der impac t on calculation.
•Logicfordet
ermining the order of members.
See Also
Chapter 9, “Creating Hierarchies,” Understanding Override Order of Precedence, page 8 2
Dimension Order Impact on Calculation
The order of dimensions in the analytic model determines which member the analytic calculation engine uses
to calculate the data cube aggregate value that exists at an intersection of two or more aggregate members.
When evaluating the data cube’s value at this intersection, the analytic calculation engineusestheaggregate
member of the dimension that appears as first in the order of dimensions in the part browser.
See C
hapter
9, “Creating Hierarch i es,” Example: Creating Overrides, page 91.
See Also
Chapter 6, “Creating Dimensions,” Changing the Order of Dimensions in th e Part Browser, page 51
Logic for Determining the Order of Members
User functions often refer to dimension m embers to calculate data cubes. For this reason, you must understand
the factors that affect the way in which the analytic calculation engine orders dimension members:
78 Copyright © 1988-2007, Oracl e. All rights reserved.