MicroStrategy ONE

4. History List Database Repository

If you are using a database-based History List, when upgrading to MicroStrategy ONE you must create the History List database tables in the test environment.

To Create the Tables in the History List Repository

  1. Open the MicroStrategy Configuration Wizard.
  2. Select Metadata, History List and Statistics Repository Tables and click Next.
  3. Select the History List Tables check box and click Next.
  4. From the DSN drop-down list, select the DSN for your History List repository.

    If a DSN for your History List repository does not exist, you can select New to open the Connectivity Wizard and create a new DSN.

  5. Type a User Name and Password that can connect to the data source.

    The database user you provide becomes the owner of all History List tables and objects. The database user is required to have the Select, Create, Insert, and Drop permissions.

  6. After providing a valid user name and password, you can click SQL Preview to open the SQL Preview dialog box. This dialog box provides the SQL statements that will be executed on your data source to create the History List tables. Click Close once you are done reviewing the SQL statements to return to the Configuration Wizard.

    If you use the advanced options to change the SQL script, you can click SQL Preview after selecting the new script to see an updated listing of the SQL statements that will be executed.

  7. Click Advanced.
  8. In the Table Prefix field, you can specify a prefix to be used when History List tables are created in the database you select. This is an optional configuration. However, you must use different prefixes for your metadata tables and your History List tables if you store them in the same database.

    Most databases use a prefix of two characters. However, you can supply as many letters, numbers, underscores (_), and periods (.) as required to support your database prefixes. To determine character limits for a prefix, refer to your third-party database vendor documentation.

    If you use a table prefix for your History List tables, you must also define this table prefix when you create a database instance to connect to the History List tables.

  9. In the Script field, a SQL script to create History List tables optimized for your database is selected. If you want to specify a different script, click ... to browse to and select a customized script
  10. Click Next.
  11. Review the summary information.

    You can click Save to save the configuration as a response (.ini) file to configure History List repositories on other systems or to run silent configurations at a later time.

  12. Click Finish to apply the configuration and create the History List repository.