Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Financial Analytics > Process of Configuring Siebel Financial Analytics for PeopleSoft 8.4 >

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 PeopleSoft 8.4.

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_fin_stmt_item_codes_psft.csv file. For example, this file might have the layout shown in Table 70.

In Table 70, all accounts within the account number range from 1000 to 139800 containing Business Unit 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 Business Unit 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.

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

To assign accounts to Group Account Numbers

1. Open the file_fin_stmt_item_codes_psft.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_fin_stmt_item_codes_psft.csv file.

3. Save and close the file.