Bookshelf v7.8.3: Configuring the General Ledger Account Hierarchies

The Siebel General Ledger Analytics application prepackages a hierarchy table (IA_HIERARCHIES) to store all hierarchy information. The Siebel General Ledger Analytics application uses this table to store Siebel General Ledger Analytics account hierarchy information. For the hierarchies to work, you first have to load the Siebel General Ledger Analytics account hierarchy information into IA_HIERARCHIES. Second, you have to configure the Source Adapter for the GL_ACCOUNTS_LOAD mapping so that the hierarchy key in the IA_GL_ACCOUNTS table links to the IA_HIERARCHIES table. After these two tasks are accomplished, you are ready to load General Ledger Account data into the IA_GL_ACCOUNTS table.

You can relate up to six possible hierarchy structures to each general ledger account, using the IA_HIERARCHIES table:

Loading the Hierarchy Definitions Into the IA_HIERARCHIES Table, The Siebel General Ledger Analytics application prepackages the M_S_GL_HIERARCHY_EXTRACT mapping to extract hierarchy definitions from SAP R/3. To better assist you in loading your hierarchy information into the IA_HIERARCHIES table, Table 67 provides descriptions of the columns presented in the table.

Table 67. Columns in the IA_HIERARCHIES Table
Column Name	Description
HIER_KEY	This surrogate key is generated for each hierarchy. This key must be linked to the HIERARCHY_KEY column in the IA_GL_ACCOUNTS table.
HIERARCHY_ID	This column uniquely identifies the hierarchy within a given category. For general ledger account hierarchies, the ID format is as follows: 'GL_HIER' \|\| <top node of hierarchy> \|\| HIER1_CODE... HIER10_CODE
HIER_CODE	This code represents a hierarchy. The hierarchy code defines the name of the hierarchy (for example, Balance Sheet, Profit and Loss, and so on).
HIER_NAME	This column provides the name of the entire hierarchy.
HIER_CAT_CODE	This code represents the category of the hierarchy. For general ledger account hierarchies, the category code is GL_HIER.
HIER_CAT_DESC	This is a description of the category to which the hierarchy belongs. For general ledger account hierarchies, the category description is General Ledger Hierarchy.
HIER_SUBCAT_CODE	This is the code of the subcategory of the hierarchy.
HIER_SUBCAT_DESC	This is a description of the subcategory of the hierarchy.
LEVEL_MIN_NUM	This is the first number, which is set to 0. For general ledger accounts, this is the first account number that is associated with this hierarchy. All accounts including and between the LEVEL_MIN_NUM and LEVEL_MAX_NUM are included in this category.
LEVEL_MAX_NUM	This is the last number, which is set to 99999999. For general ledger accounts, this is the last account number that is associated with this hierarchy. All accounts including and between the LEVEL_MIN_NUM and LEVEL_MAX_NUM are included in this category.
HIERX_CODE	Each of these code columns represents a level in the hierarchy, where [X] denotes the level. HIER1 is the highest level of the hierarchy, and HIER20 is the lowest. Each code name column (HIER[X]_NAME) corresponds to a code column (HIER[X]_CODE). The code of the highest level of the hierarchy is catenated with GL_ACCT to form the hierarchy of the IA_HIERARCHIES table.
HIER_ATTRX_CODE and HIER_ATTRX_NAME	There are five sets of extension columns for code name pairs. The X represents the level, where the same level is shared by each code name pair, such as HIER_ATTR1_CODE and HIER_ATTR1_NAME.
HIER_ATTRX_TEXT	These are extension columns to store additional text. There are three available for your use.

You must set the Hierarchy ID for every hierarchy structure. The following format is recommended:

For example, if one of the general ledger account hierarchies has the following structure:

where the Balance Sheet hierarchy level is the highest level of the hierarchy, and BS denotes the hierarchy code, then set the Hierarchy ID to: