KB38745: What tables and views are affected when running a Warehouse Data Deletion for MicroStrategy Enterprise Manager 9.x?

• Strategy

What tables and views are affected when running a Warehouse Data Deletion for MicroStrategy Enterprise Manager 9.x?

When using the Strategy Enterprise Manager 9.x Console and running the Warehouse Data Deletion for a specified custom time window, the following SQL statements are run against the Enterprise Manager Warehouse:

DELETE FROM IS_SESSION WHERE EM_RECORD_TS BETWEEN 'StartDate' AND 'EndDate'
DELETE FROM IS_SESSION_TMP WHERE RECORDTIME BETWEEN 'StartDate' AND 'EndDate'
DELETE FROM IS_SESSION_TMP1 WHERE EM_RECORD_TS BETWEEN 'StartDate' AND 'EndDate'
DELETE FROM IS_SESSION_TMP2 WHERE EM_RECORD_TS BETWEEN 'StartDate' AND 'EndDate'
DELETE FROM IS_REP_FACT WHERE EM_RECORD_TS BETWEEN 'StartDate' AND 'EndDate'
DELETE FROM IS_DOC_FACT WHERE EM_RECORD_TS BETWEEN 'StartDate' AND 'EndDate'
DELETE FROM IS_PROJECT_FACT_1 WHERE EM_RECORD_TS BETWEEN 'StartDate' AND 'EndDate'
The only tables affected are IS_SESSION, IS_SESSION_TMP, IS_SESSION_TMP1, IS_SESSION_TMP2, IS_REP_FACT and IS_DOC_FACT, IS_PROJECT_FACT_1.

Note: The Report 'Data Load History' will still contain all the history of previous data loads from the tables EM_LAST_UPDATE.

Comment

0 comments

Details

Knowledge Article

Published:

June 8, 2017

Last Updated:

June 8, 2017