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

Configuring Hierarchy ID in Source Adapter for Siebel General Ledger Analytics

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

To configure the Siebel General Ledger Analytics application to link to the General Ledger Account hierarchies from the IA_HIERARCHIES table, you must configure the Source Adapter in the GL_ACCOUNTS_LOAD mapping. By default, the HIERARCHY_KEY port is set to NULL. To populate the Siebel General Ledger Analytics account hierarchies when you load the IA_GL_ACCOUNTS table, use the same hierarchal structure that you used in IA_HIERARCHIES. For more information on the hierarchal structure used in IA_HIERARCHIES, see Configuring the General Ledger Account Hierarchies.

To configure the Hierarchy ID

1. In PowerCenter Designer, open the Configuration for SAP R/3 folder.
2. In Mapping Designer, open the mapping M_S_GL_ACCOUNTS_LOAD.
3. Double-click the Expression transformation to open the Edit Transformations window.
4. Edit the HIERX_KEY port (X denotes a distinct hierarchy structure).
5. Change NULL to reflect the Hierarchy ID specified in the HIERARCHY_KEY column in the IA_HIERARCHIES table.
6. Validate and save your changes to the repository.