ETL Utilities

What is the Language Swap utility?

If the source database base language is different from the EPM database base language, you must ensure that the EPM base tables have descriptions in EPM base language and the related language table have descriptions in EPM installed foreign language. The Language Swap ETL utility provides this functionality.

For more information on the language swap utility, see the Setting Up Multilanguage Processing and Running the Language Swap Utility topic in your warehouse specific documentation (for example, the PeopleSoft Campus Solutions Warehouse).

What are related language tables and how are they packaged?

In EPM, every table that requires language translation has a corresponding related language table. ETL jobs to populate these language tables are created. These jobs are packaged along with the base table jobs. Running these jobs is optional, since not all of them require the use of multi-language functionality.

What is the Currency Conversion utility?

This utility is used to populate the reporting amount and reporting currency code columns in fact tables in the Multidimensional Warehouse. This population is considered an ETL post process. Before running the ETL, the setup for MDW Currency Conversion definitions should be completed in the PIA pages.

For more information on the MDW currency conversion utility, see the Implementing Currency Conversion for Multiple Currencies topic in your warehouse specific documentation (for example, the PeopleSoft Campus Solutions Warehouse).

What are tree-processing jobs?

If a warehouse or data mart has tree or recursive hierarchy data, the ETL utility to process this data must be triggered. The utility flattens and denormalizes the set of hierarchies. These hierarchy definitions needs to defined in PIA pages before running the ETL jobs.

For more information on the MDW tree flattening process, see the Processing Trees and Recursive Hierarchies topic in your warehouse specific documentation (for example, the PeopleSoft Campus Solutions Warehouse).

What are the Dimension Mapper jobs?

Dimension mapper jobs refer to a set of jobs that enable users to set up Warehouse Business Units and SetIDs. This mapper tool utilizes data from several other tables such as PF_SRC_SETCNTRL, PF_SRC_BU_NAMES, and PF_SRC_BU_ROLES, which are loaded by the dimension mapper jobs.

The output tables of the Dimension Mapper tool are PF_SETID_LOOKUP, PF_BUS_UNIT_MAP, BUS_UNIT_TBL_PF, BUS_UNIT_TBL_FS, SETID_TBL, SET_SNTRL_TBL, SET_CNTRL_GROUP, and SET_CNTRL_REC. These tables are used as lookups in ETL job design.

See Understanding Warehouse Business Units, TableSet Sharing, and SetID Mapping and Understanding Warehouse Business Unit Setup.