Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Financial Analytics > Process of Configuring Siebel Financial Analytics for SAP R/3 >

Configuring the Group Account Number Categorization for Siebel General Ledger Analytics

This task is a step in the Process of Configuring Siebel Financial Analytics for SAP R/3.

NOTE:  It is critical that the General Ledger Account Numbers are mapped to the Group Account Numbers (or domain values) as the metrics in the General Ledger reporting layer uses these values. For a list of domain values for General Ledger Account Numbers, see Siebel Customer-Centric Enterprise Warehouse Data Model Reference.

The mappings to General Ledger Accounts Numbers are important for both Profitability Analysis (Income Statement) and General Ledger accounts.

The Group Account Number categorizes each Siebel General Ledger Analytics account record in the IA_GL_ACCOUNTS dimension table. Each Siebel General Ledger Analytics Account is assigned a Group Account Number. The logic for assigning the accounts is located in the file_group_acct_codes_sapr3.csv file. For example, this file might have the layout shown in Table 65.

In Table 65, all accounts within the account number range from 1000 to 139800 containing Hierarchy Code equal to GL_HIER and Company Code equal to 1 are assigned to Account Depreciation (ACCN DEPCN). Similarly, looking at the second row in the table, all accounts within the account number range from 140000 to 141099 containing Hierarchy Code equal to GL_HIER and Company Code equal to 1 are assigned to AR. Each row categorizes all accounts within the specified account number range and with the given combination of Hierarchy Code and Company Code.

Because different Hierarchy Code and Company Code combinations can contain the same account numbers, the Hierarchy Code and Company Code is also contained in this file. By keeping note of the account number as well as the Hierarchy Code and Company Code, you can uniquely identify each transaction in the data warehouse.

NOTE:  You must capitalize the letters for the GROUP_ACCT_NUM column.

To assign accounts to Group Account Numbers

1. Open the file_group_acct_codes_sapr3.csv file in the $pmserver\srcfiles folder.
2. Remove all entries in the file and insert your account ranges for each Group Account Number.

   For list of values for Group Account Numbers, please see the MASTER_CODE column in the file_group_acct_names_sapr3.csv file.

3. Save and close the file.