Remove store data
If you no longer want to perform business intelligence and analysis for a store, you can stop the replication and ETL processes and remove the store data from the data mart.
To stop the replication and ETL processes:
- Determine the store ID of the store on which you no longer want to run reports.
- To determine the store ID of your store, check the STOREENT table. The STOREENT_ID is the value used for the store ID. The STOREENT_ID for you store is the one that corresponds to the STOREENT.IDENTIFIER for your store.
- Open the WebSphere Commerce Analyzer Parameter Manager.
- Select the Stores entry to open the Select Stores, Report Language and Currency page.
- Clear the check box associated with the store ID and click Apply.
If you want to keep the data mart for historical reasons, do not perform the following steps. Otherwise, to remove the store data from the data mart:
- Connect to the WebSphere Commerce Analyzer data mart as the owner of the data mart.
- Remove all of the rows in the fact tables containing the store ID of the store that you want to remove.
Fact tables have names that begin with FACT_xxxxx.
- Remove all of the rows in the dimension tables containing the store ID of the store you want to remove. Dimension tables have foreign keys to the fact tables.
To find the dimension tables for a FACT_xxxxx table, refer to the database table information.
The Constraints section of a FACT_xxxxx database table information page lists the dimension tables with foreign keys to that FACT_xxxxx table.
- Remove the row in the WCA.STORE table containing the store ID of the store you want to remove.
(C) Copyright IBM Corporation 1996, 2006. All Rights Reserved.