Reference tables
WebSphere Commerce Analyzer uses reference tables when descriptions are required in multiple languages for rows in the data mart. The LANGUAGE_ID column in the replication table enables a replication tool to limit the language displayed. The REPORT_LANGUAGE parameter type in the WCA.PARAMETERS table is used in conjunction with the LANGUAGE_ID column in each reference table to provide the information in the WebSphere Commerce Analyzer language chosen as the default language. This parameter is also used by the WebSphere Commerce Analyzer ETL process to map from WebSphere Commerce.
Some reference tables are copied from the WebSphere Commerce database while others are populated using a predefined properties file, which contains additional descriptions for the WebSphere Commerce Analyzer data mart.
During the configuration step Loading Languages and Financial Periods Texts, the reference tables are populated and period descriptions are added for each period loaded into the period table. For more information about configuration, see the WebSphere Commerce Analyzer chapter in the WebSphere Commerce Additional Software Guide.
(C) Copyright IBM Corporation 1996, 2006. All Rights Reserved.