Con

Puts data into the [Proportion] and [Elimination] Value dimension members. This function can be used in Consolidation rules.

Syntax

Hs.Con (*" DestPOV ", Factor, " Nature ")

Table 11-12 Syntax for Con Function

Parameter	Description
DestPOV	Combination of these elements: Account Custom1, Custom2, Custom3, Custom4 Intercompany Entity Value
Factor	A number or an expression using mathematical operators (+ - * /) or functions such as HS.GetCell.
Nature	A string used for audit purposes. This string is stored in the database and provides information about the accounting purpose of the transaction. To allow users to view consolidation source and destination transactions after running a consolidation, you must include text in this parameter. If you do not include text, the transaction information is not stored. You can view transaction information from data grid Source or Destination Transaction options, or from the Entity Detail report. You can also use the Nature string information to generate journal reports for consolidation and elimination entries. If you want to see tis data in a journal report, this parameter is required. Journals for Proportion and Elimination entries are reported from RTS/RTD tables. Depending on your requirements, it may be appropriate to create the journal data for [Elimination] HS.Con entries, but not for [Proportion] HS.Con entries to reduce the volume of RTS/RTD table entries. Using the Nature parameter, which generates RTS/RTD table entries, increases the size of the database and may impact consolidation performance.

Parameter

Description

DestPOV

Combination of these elements:

Account
Custom1, Custom2, Custom3, Custom4
Intercompany
Entity
Value

Factor

A number or an expression using mathematical operators (+ - * /) or functions such as HS.GetCell.

Nature

A string used for audit purposes. This string is stored in the database and provides information about the accounting purpose of the transaction.

To allow users to view consolidation source and destination transactions after running a consolidation, you must include text in this parameter. If you do not include text, the transaction information is not stored. You can view transaction information from data grid Source or Destination Transaction options, or from the Entity Detail report.

You can also use the Nature string information to generate journal reports for consolidation and elimination entries. If you want to see tis data in a journal report, this parameter is required. Journals for Proportion and Elimination entries are reported from RTS/RTD tables. Depending on your requirements, it may be appropriate to create the journal data for [Elimination] HS.Con entries, but not for [Proportion] HS.Con entries to reduce the volume of RTS/RTD table entries.

Using the Nature parameter, which generates RTS/RTD table entries, increases the size of the database and may impact consolidation performance.

Return Value

None.

Example

Call HS.Con ("V#[Elimination]",-1*dPCon,"")

Call HS.Con ("V#[Elimination]",-1*dPCon, "Elimination")

Call HS.Con ("V#[Elimination]"PCON, "DefaultConsolidation")