Parameters affect the state of the data mart after you perform an extraction. These parameters control the execution of the system and also control the analytic conclusions. Parameters are modified using the WebSphere Commerce Analyzer Parameter Manager.
The following table illustrates which parameters in the WCA.PARAMETERS table each page in the WebSphere Commerce Analyzer Parameter Manager edits.
Pages in WebSphere Commerce Analyzer Parameter Manager | WebSphere Commerce Analyzer Parameters |
Select Stores, Report Language and Currency page | store, REPORT_CURRENCY, REPORT_LANGUAGE |
Select Catalog | ANALYSIS_CATALOG_ID |
Select Mining Models | MINING_USER_NAME, MINING_APPLY_TIME, MINING_BASE_NAME, MINING_PASSWORD, MINING_TRACE, MINING_TRAINING_INTERVAL, MINING_TRAINING_TIME, MINING_USER_ID |
Select Orders to be Totaled by RFM page | RFM_INTERVAL, RFM_BINS, RFM_LAST_RUN, ORDER_STATUS_ID_SUM_MEMBER, ORDER_STATUS_ID_SUM_TRADING, ORDER_STATUS_XFERRED, RFM_LAST_RUN |
Determine Abandoned Orders Criteria | ABANDONED_MINUTES, ABANDONED_ORD_STATUS |
Select Order Item Status Attributes | NON_PURGE_ORD_STATUS, ORDERS_AWAITING_PAYMENT, ORDER_STATUS_BILLED, ORDER_STATUS_CANCELLED, ORDER_STATUS_COLLECTED, ORDER_STATUS_ID_NOREV |
Select Member Attributes | ADDRESS_MEMBER_TYPE_ID, DMT_PROSPECT_ORD_STATUS, DMT_PURCHASER_ORD_STATUS |
Associate Contract Status with Report Contract Status | CONTRACT_ACTIVE, CONTRACT_IN_PREPARATION, CONTRACT_CANCELLED |
Load Language and Financial Periods | many _REF tables |
Associate Orders with Coupon Promotions, Campaign Activities, and Metaphors | FE_EFFECTIVE_MINUTES, FE_EFFECTIVE_ORD_STATUS, FM_EFFECTIVE_MINUTES, FM_EFFECTIVE_ORD_STATUS, CPN_REDEEMED_ORDER_STATUS |
Determine Orders Deleted by User Criteria | NON_PURGE_ORD_STATUS |
Select WebSphere Commerce Analyzer Parameters | PRODUCT_PRICE_AGGREGATE, ORG_BUSINESS_TYPE, ORG_INDUSTRY_TYPE, HOTSPOT_LIMIT, WSA_PARM_TYPE |