Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Financial Analytics > Process of Configuring Siebel Financial Analytics for Oracle 11i >

Mapping Siebel General Ledger Analytics Account Numbers to Group Account Numbers

This task is a step in the Process of Configuring Siebel Financial Analytics for Oracle 11i.

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.

You can categorize your Oracle General Ledger accounts into specific group account numbers. You may use this information during data extraction as well as front-end reporting. The GROUP_ACCT_NUM field denotes the nature of the Siebel General Ledger Analytics accounts. For example, Cash account, Payroll account, and so on. Refer to the master_code column in the file_group_acct_names_ora11i.csv file for values you can use. For a list of the Group Account Number domain values, see Siebel Customer-Centric Enterprise Warehouse Data Model Reference.

There are two columns in the fact table that categories expenses—Xact Type Key (Cost Types) and Xact Type Alloc Key (Cost Allocation Type). The Xact Type Key categorizes the expenses into Marketing, Sales, Service, and so on. The Xact Type Alloc Key further categorizes these into Direct and Allocation expenses.

NOTE:  It is critical that you map the Xact Type Key and Xact Type Alloc Key columns for reports to work.

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

The logic for assigning the accounts is located in the file_group_acct_codes_ora11i.csv file. Table 63 shows the layout of the file_group_acct_codes_ora11i.csv file.

In Table 63, in the first row, all accounts within the account number range from 101010 to 101099 containing a Set of Books (SOB) ID equal to 1 are assigned to Current Asset. Each row maps all accounts within the specified account number range and with the given Set of Books ID.

If you need to create a new group of account numbers, you can create new rows in the file_group_acct_names_ora11i.csv file. You can then assign GL accounts to the new group of account numbers in the file_group_acct_codes_ora11i.csv file.

NOTE:  When you specify the Group Account Number, you must capitalize the letters and use the values in the master_code column of the file_group_acct_names_ora11i.csv file.

To map Siebel General Ledger Analytics Accounts to Group Account Numbers

1. Open the file_group_acct_codes_ora11i.csv file with Microsoft WordPad or Notepad in the $pmserver\srcfiles folder.
2. Edit the fields in the following table:

   Field Name	Description
   SOB ID	The set of books ID for the Siebel General Ledger Analytics accounts.
   FROM ACCT and TO ACCT	The From Account and To Account specify the range of Siebel General Ledger Analytics accounts for the mapping. The value you specify comes from the value of the natural account segment of the Siebel General Ledger Analytics account.
   GROUP_ACCT_NUM	This field denotes the nature of the Siebel General Ledger Analytics accounts. For example, Cash account, Payroll account, and so on. Refer to the file_group_acct_names_ora11i.csv file for values you can use.

   NOTE:  It is important that you do not edit any other fields in the CSV files.

3. Save and close the CSV file.