US Eliminations 
A US Elimination books the eliminated transaction into an elimination entity and account between entity and intercompany. The driving elements of this procedure are:
-
The ELIM property of entity dimension
-
The ELIMACC property of account dimension
-
The US Elimination rule assigned to each DataSrc to elimination
You run this rule by calling the stored procedure SPRUNELIM(parameters list). This stored procedure performs the eliminations driven by the hierarchies in the Entity dimension and writes the elimination in an Entity member (property ELIM=Y).
*RUN_STORED_PROCEDURE = SpRunElim ([%APP%], [%CATEGORY_SET%], [%TIME_SET%], [], [H1], [%LOGTABLE%],[%SCOPETABLE%])
The stored procedure requires several parameters that must be passed to it in the correct order and format, as described below.
|
Parameter |
Description |
Can Be Blank |
Value |
|
Application |
The application ID. The name of the main application where the SPRUNELIM must be performed. |
No |
Single |
|
Category |
The name of the data category to process. The system supports the handling of only one category at a time. Alternatively, SPICDATA can be triggered multiple times in a loop of categories within the logic file. |
No |
Single |
|
Time |
The names of the Time members to process. Time must be entered in the format |
No |
Multi |
|
Group |
Valid members of the reporting currency to process. (Cannot be from the local currency.) If blank, all reporting currencies are taken. |
Yes |
Multi |
|
Hierarchy |
The name of the hierarchy in the Entity dimension on which to perform the US elimination. For example, H1 or H2. |
Yes |
Single |
|
%LOGTABLE% |
This keyword is used internally by the procedure to identify the name of a table where the procedure writes logging information. At the end, this information is copied into the logic log file and the table is deleted. |
Yes (Keyword) |
Single |
|
%SCOPETABLE% |
This keyword checks the work status settings. If there are records that are rejected because their status is set to locked, none of the records calculated by the data package are inserted. An error message is returned with detailed information. |
Yes (Keyword) |
Single |
Business Rules – U.S. Elimination
The US Elimination table in the Business Rules area of the Admin Console defines the original data source and the destination data source.
|
Column Name |
Length |
Description |
|---|---|---|
|
DATASRC |
20 |
A valid member of the DATASRC dimension. |
|
DEST_DATASRC |
20 |
A valid member of the DATASRC dimension. |
|
COMMENT |
250 |
A meaningful description of the US Elimination rule. |
The Entity Dimension
The ELIM property is used to define the entity where the elimination is written.
|
Property Name |
Length |
Description |
|---|---|---|
|
ELIM |
10 |
Y or blank. If Y, the calculated elimination is booked. |
The Account Dimension
The ELIMACC property is used to indicate which account must be eliminated.
|
Property Name |
Length |
Description |
|---|---|---|
|
ELIMACC |
20 |
A valid member of the Account dimension to save eliminated data. |