Understanding 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.

The following table describes the PSACETREEOVRD subrecord.

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 member.	MIN, IGN Note: The default value in the OPERATION field is null, causing the analytic calculation engine to use the sum operator for aggregating members. Other possible values in the table are MIN for subtraction aggregation and IGN for ignore.

Note:

The PSACETREEOVRD subrecord must contain a value in either or both of the OPERATION or ACERULEID fields. If both of these fields are null, the analytic calculation engine ignores the row.