Technical data

ManualsBrandsSimplicity ManualsDo-It-Yourself tools4564

101

102

103

104

105

106

107

108

109

110

Creating Hierarchies Chapter 9

See Also

Chapter 9, “Cre

ating Hierarchies,” Examp l e: Using Default Aggr eg ation, page 84

Chapter 9, “Creating Hierarchies,” Example: Creating a Hierarchy with Mixed Aggregate and Detail

Members, page 109

Understandin

g the PSACETREEOVRD Subrecord

You use the PSACETREEOVRD subrecord to assign an override to a tree. To use the subrecord, you must first

create a record definition. This record definition can contain additional fields. After you create the record

definition, insert the PSACETREEOVRD subrecord into the record definition.

To attach the PSACETREEOVRD subrecord to a tree, specify the name of the override record as the

RecordName parameter of the AttachTree method.

This table de

scribes the PSACETREEOVRD:

Field Name Description Possible Values

TREE_NAME

The name of the tree that contains the

node to override.

DEPT_TREE

SET_ID

The setID of the tree.

123

EFFDT

The effective date of the tree. 12/1/03

TREE_NODE

The name of the dimension member on

which the override should operate.

GBL

ACERULEID

The name of the user function to apply

as an override. This field can be null

because it can be reused.

USER_FUNCTION_NAME

OPERATION

Add, subtract, or ignore this entry

when aggregating a parent mem ber.

MIN, IGN

Note. The default value in the

OPERATION field is null, causing

the analytic calculation engine to

use the su m operator for aggregating

members. Other possible values in

the table ar e MIN for subtraction

aggregation and IGN for igno re.

Note. The PSACETREEOVRD subrecord must contain a value in either or both of the OPERAT ION or

ACERULEID fields. If both of these fields are null, the analytic calculation engine ignores the row.

Example: Using Default Aggregation

This section provides an example of how to create an analytic model that uses d efault aggregation.

Requirements for Analytic Model

This table provides an example of a table named MainData, which you specified as the main record of a

cube collection: