SUMMARY
The following technical document provides the scripts to extend the partitions on the Statistics tables and Enterprise Manager Warehouse fact tables, and also extend the Strategy Enterprise Manager Warehouse Date Dimension tables in version 9.x beyond year 2015.
INTRODUCTION
In Strategy 9.x, the Enterprise Manager Warehouse database contains data only until year 2015 (December 31, 2015) for the following Date Dimension tables:
Also, the partitions on all the Statistics tables and Enterprise Manager Warehouse tables only exist till the end of year 2015.
ACTION
Starting with Strategy Enterprise Manager 10, the Enterprise Manager Warehouse date data has been extended until the year 2020.
If it is required to extend the dates and partitions on a pre-10 environment, the the following scripts can be used on a Strategy Enterprise Manager Warehouse version 9.x.
Important Note: Customers should make a backup of their Enterprise Manager Warehouse before running the scripts.
The following files are part of the zip file attached to the end of this document:
EM_941_Extension_2020_DB2.zip
- EM_WH_Date_Ext_DB2.sql
- EM_WH_Partition_Ext _DB2.sql
EM_941_Extension_2020_MySQL.zip
- EM_WH_Date_Ext_MySQL.sql
EM_941_Extension_2020_Oracle.zip
- EM_WH_Date_Ext_Oracle.sql
- EM_WH_Partition_Ext_Oracle.sql
EM_941_Extension_2020_SQL_Server.zip
- EM_WH_Date_Ext_SQL_Server.sql
- EM_WH_Partition_Ext_SQL_Server.sql
EM_941_Extension_2020_Sybase.zip
- EM_WH_Date_Ext_Sybase.sql
EM_941_Extension_2020_Teradata.zip
- EM_WH_Date_Ext_Teradata.sql
- EM_WH_Partition_Ext_Teradata.sql
Users should select the script based on their Enterprise Manager Warehouse database type and partitioning requirements.
The script for extending Teradata partitions can be found in the following Strategy Knowledge Base Technical Document:
KB219015: How to extend partitions beyond January 2015 for MicroStrategy Enterprise Manager 9.3.x - 9.4.x on Teradata 13.x or 14.x
If you are using Strategy Enterprise Manager 2020, see KB484050: Manually extend MicroStrategy Enterprise Manager 2020 dimension tables and partitions on Statistic tables beyond the year 2020.
Note: Users who downloaded the Oracle partition extension script before 1/5/2016 will experience a loss of data for DAY_ID Dec 1st 2015 and later. To fix this issue, users should roll back to a backup of the Statistics tables/Enterprise Manager and run the new scripts which have been posted to this Technical Note.
This has been logged as Strategy Internal Reference number US28100.
KB270405
