Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Checklist for Configuring Siebel Customer-Centric Enterprise Warehouse Applications >
Checklist for Configuring the Siebel Financial Analytics
This section contains the mandatory and optional configuration points for the Financial applications for Oracle 11i, SAP R/3, and PeopleSoft 8.4. The Financial applications consist of Siebel General Ledger Analytics, Siebel Payables Analytics, Siebel Receivables Analytics, and Siebel Profitability Analytics. Checklist for Configuring the Siebel Financial Analytics for Oracle 11i
This section contains the Siebel Financial Analytics applications configuration points that are specific to Oracle 11i. The following section contains mandatory Siebel Financial Analytics configuration points: - Extracting Data Posted at the Detail-Level. By default, the Siebel Customer-Centric Enterprise Warehouse assumes that the posting from your journal to your General Ledger is done at summary level and that references are maintained in the General Ledger for AP and AR subledgers. Configuration is required if import references are not maintained in the General Ledger and the posting from subledgers is at the detail level. For more information on extracting data posted at the detail-level, see Extracting Data Posted at the Detail-Level for Oracle 11i.
- Mapping General Ledger Analytics account numbers to group account numbers. You need to map General Ledger Analytics account numbers to group account numbers. For more information on mapping General Ledger accounts numbers to group account number, see Mapping Siebel General Ledger Analytics Account Numbers to Group Account Numbers.
The following section contains optional Siebel Financial Analytics configuration points: - Configuring the Set of Books ID. By default, the Siebel Customer-Centric Enterprise Warehouse extracts data for all set of books. Configuration is required to extract data for a certain set of books only. For more information on filtering extracts based on Set of Book ID, see Filtering Extracts Based on Set of Books ID for Siebel General Ledger Analytics.
- Configuring posted or unposted transactions. By default, Siebel Customer-Centric Enterprise Warehouse extracts posted transactions. You can configure the Siebel Customer-Centric Enterprise Warehouse to extract unposted transactions as well as posted transactions. For more information on configuring the General Ledger transaction extracts and COGS extract, see Configuring Siebel General Ledger Analytics Transaction Extracts and Configuring General Ledger Cost Of Goods Extract.
- Configuring General Ledger account hierarchies. Additional configuration is required to make sure the General Ledger hierarchical information is correct and to load the IA_HIERARCHIES table. For more information on configuring the General Ledger account hierarchies and loading hierarchies into the IA_HIERARCHIES table, see Configuring the General Ledger Account Hierarchies and Loading Hierarchies for Siebel General Ledger Analytics.
- Configuring the General Ledger Balance ID. By default, the General Ledger Balance ID is maintained at the Set of Books and GL Code Combination ID level. If you want to maintain your General Ledger Balance at a different grain, you can redefine the GL Balance ID. For more information on configuring the General Ledger Balance ID, see Configuring the General Ledger Balance ID.
- Configuring the AP Balance ID. If you want to maintain your AP balance at a different grain, you can redefine the Balance ID value in the applicable mapplets. For more information on configuring the AP Balance ID, see Configuring AP Balance ID for Siebel Payables Analytics.
- Configuring the AR Balance ID. If you want to maintain your AR balance at a different grain, you can redefine the Balance ID value in the applicable mapplets. For more information on configuring the AR Balance ID, see Configuring AR Balance ID for Siebel Receivables Analytics and Siebel Profitability Analytics.
- Configuring the AR Adjustments Extract. If you want to extract additional types of AR adjustment entries, you can remove the filter in the Business Component mapplet. For more information on configuring the AR adjustments extract, see Configuring the AR Adjustments Extract for Siebel Receivables Analytics.
- Configuring the AR Schedules Extract. If you want to extract additional types of AR schedule entries, you must remove the filter in the Business Component mapplet. For more information on configuring the AR schedules extract, see Configuring the AR Schedules Extract.
- Configuring the AR Cash Receipt Application Extract. If you want to extract additional types of cash-receipt application entries, you can remove the filter in the Business Component mapplet. For more information on configuring the AR receipt application extract, see Configuring the AR Cash Receipt Application Extract for Siebel Receivables Analytics.
- Configuring the AR Credit-Memo Application Extract. If you want to extract additional types of credit-memo application entries, you can remove the filter. For more information on configuring the AR receipt application extract, see Configuring the AR Credit-Memo Application Extract for Siebel Receivables Analytics.
- Configuring the Customer Costs and Product Costs Fact Tables. In Siebel Profitability Analytics, the Customer Costs and Product Costs fact tables store the costing and expenses for the Profitability functional area. You need to use these tables with General Ledger Revenue and General Ledger COGS fact tables. For more information on configuring the Customer Costs and Product Costs Fact Tables, see Configuring the Customer Costs Lines and Product Costs Lines Tables for Siebel Profitability Analytics.
Checklist for Configuring the Siebel Financial Analytics for SAP R/3
This section contains the Siebel Financial Analytics configuration points that are specific to SAP R/3. The following section contains mandatory Siebel Financial Analytics configuration points: - Extracting Data Posted at the Header Level. By default, the Siebel General Ledger Analytics application extracts sales information posted to the General Ledger at the detail level. However, you can configure the extraction if your installation of SAP R/3 is configured to store data at the header level. For more information on extracting data posted at the header level, see Extracting Data Posted at the Header Level for SAP R/3.
- Mapping General Ledger Analytics account numbers to group account numbers. You need to map General Ledger Analytics account numbers to group account numbers. For more information on mapping General Ledger accounts numbers to group account number, see Configuring the Group Account Number Categorization for Siebel General Ledger Analytics.
The following section contains optional Siebel Financial Analytics configuration points: - Configuring General Ledger account hierarchies. Additional configuration is required to make sure the General Ledger hierarchical information is correct and to load the IA_HIERARCHIES table. For more information on configuring the General Ledger account hierarchies and loading hierarchies into the IA_HIERARCHIES table, see Configuring the General Ledger Account Hierarchies and Configuring Hierarchy ID in Source Adapter for Siebel General Ledger Analytics.
- Configuring General Ledger Balance Extract. By default, this is maintained at GL account—Company—Business Area—Client level. The Client is used to distinguish source instances if you have multiple source instances for your data warehouse. To change the grain at which you accumulate the General Ledger balance, modify the Balance ID or Key ID definition. For more information on configuring General Ledger Balance Extract, see Configuring the Siebel General Ledger Analytics Balance Extract.
- Configuring the transaction types. You can configure the transaction type by editing the xact_type_code_sap.csv file. For more information on configuring Configuring the transaction types, see Configuring the Transaction Types for Siebel Financial Analytics.
- Configuring the AP Balance ID. If you want to maintain your AP balance at a different grain, you can redefine the Balance ID value in the applicable mapplets. For more information on configuring the AP Balance ID, see Configuring the Siebel Payables Analytics Balance Extract.
- Configuring the AR Balance ID. If you want to maintain your AR balance at a different grain, you can redefine the Balance ID value in the applicable mapplets. For more information on configuring the AR Balance ID, see Configuring the Siebel Receivables Analytics Balance Extract.
- Configuring the Customer Costs and Product Costs Fact Tables. In Siebel Profitability Analytics, the Customer Costs and Product Costs fact tables store the costing and expenses for the Profitability functional area. You need to use these tables with General Ledger Revenue and General Ledger COGS fact tables. For more information on configuring the Customer Costs and Product Costs Fact Tables, see Configuring the Customer Costs Lines and Product Costs Lines Tables for Siebel Profitability Analytics.
Checklist for Configuring the Siebel Financial Analytics for PeopleSoft 8.4
This section contains the Siebel Financial Analytics configuration points that are specific to PeopleSoft 8.4. The following section contains mandatory Siebel Financial Analytics configuration points: - Mapping General Ledger Analytics account numbers to group account numbers. You need to map General Ledger Analytics account numbers to group account numbers. For more information on mapping General Ledger accounts numbers to group account number, see Configuring the Primary Ledger Name for Siebel General Ledger Analytics.
- Configuring the Primary Ledger name. By default, the name of the Primary Ledger is set to LOCAL for PeopleSoft. However, if the name of your Primary Ledger is not LOCAL, you can change this value by modifying the file_parameters_psft84.csv file. For more information on configuring the Primary Ledger name, see Process of Configuring Siebel Financial Analytics for PeopleSoft 8.4.
- Configuring PeopleSoft Trees. For PeopleSoft, the Siebel Financial Analytics application sources data from a data structure, called PeopleSoft Trees, to get information about the organization's General Ledger hierarchies, and so on. For a PeopleSoft environment with different tree names to the Siebel Financial Analytics application, you need to import these into the PowerCenter repository, and replace the old tree names with the new tree names. For more on PeopleSoft Trees, see About PeopleSoft Trees in Siebel Financial Analytics, Customizing the PeopleSoft Tree Names, and Importing PeopleSoft Trees Into the PowerCenter Repository.
Checklist for Configuring the Siebel Financial Analytics for Post-Load Processing
This section contains the Siebel Financial Analytics configuration points that are specific to post-load processing. The following section contains optional Siebel Financial Analytics configuration points:
|