MicroStrategy ONE

Configure Intelligence Server to Log Statistics

Below is a high-level overview of the steps to configure a project to log statistics.

Creating the Statistics Database

You can store Intelligence Server statistics in an existing database in your system, or create a new database.

Do not store the statistics in the same database that you are using for either your MicroStrategy metadata or your data warehouse.

  • To use an existing database, note its Data Source Name (DSN). This DSN is used when you create the statistics tables.

    If you choose to use Enterprise Manager to analyze the statistics, this DSN is also used to specify the data warehouse location for Enterprise Manager. For information on Enterprise Manager, see the Enterprise Manager Help.

  • To create a new database, follow the procedure below. For a list of databases that are certified for use with Intelligence Server statistics, see Overview of Intelligence Server Statistics, or see the Readme.

To Create a New Statistics Database

  1. Create the empty data warehouse database. (This is generally performed by your database administrator.) This database must be one of the databases certified for Intelligence Server statistics, as listed in the Readme.
  2. Use the MicroStrategy Connectivity Wizard to create a Data Source Name for the data warehouse. Make note of this DSN for later.

    To access the Connectivity Wizard, go to Start > All Programs > MicroStrategy Tools > Connectivity Wizard. For detailed instructions on using the Connectivity Wizard, see the Installation and Configuration Help.

    To avoid a situation in which some statistics database entries reports have incomplete information, synchronize the time of the Intelligence Server machine with the database time, if possible.

Creating Statistics Tables in the Statistics Database

After the statistics database has been created, or you have noted your existing database's DSN, you need to create the empty statistics tables for Intelligence Server to use. The MicroStrategy Configuration Wizard walks you through this process.

To Create the Empty Statistics Tables

  1. Start the MicroStrategy Configuration Wizard.
    • Windows: go to Start > All Programs > MicroStrategy Tools > Configuration Wizard.
    • Linux: Browse to the directory specified as the home directory during MicroStrategy installation. Browse to the folder bin and type ./mstrcfgwiz and press Enter.
  2. On the Welcome page, select Create Metadata, History List and Enterprise Manager Repositories and click Next.
  3. Select the Statistics & Enterprise Manager option and clear the other options. Click Next.
  4. From the DSN drop-down list, select the Data Source Name for the database that will contain your Enterprise Manager repository (the same database that you will use to log Intelligence Server statistics).

    Any table in this database that has the same name as a MicroStrategy statistics table is dropped. For a list of the MicroStrategy statistics tables, see the Intelligence Server Statistics Data Dictionary.

  5. In the User Name and Password fields, enter a valid login and password for the data warehouse database.

    The user name you specify must have permission to create and drop tables in the database, and permission to create views.

  6. If you want to use a custom SQL script for creating the repository, click Advanced.
    • In the Script field, the default script file name is displayed. The selected script depends on the database type that you specified earlier.
    • To select a different script, click ... (the Browse button) to browse to and select a script that corresponds to the DBMS for the repository.
  7. Click Next.

    If Enterprise Manager statistics tables already exist in this database, it prompts you for whether to re-create the tables. To re-create them, click Yes. To leave the existing tables in place, click No.

    Clicking Yes deletes the existing tables and all information in them.

  8. Click Finish.

Setting the Statistics Database Instance for a Project

Once the statistics repository has been created, you must configure your project to log statistics to this database.

MicroStrategy recommends that you configure your system to use single instance session logging. In this configuration, statistics for all projects in a project source are logged to a single database. To enable single instance session logging, in the Intelligence Server Configuration Editor, in the Statistics: General category, select Single Instance Session Logging and, from the drop-down list, select a project. Then specify that project's statistics database using the procedure below. For steps on enabling single instance session logging, see Overview of Intelligence Server Statistics.

To Set Up a Project to Log Statistics

  1. In Developer, log in to the server (three-tier) project source containing the projects for which you want to log statistics. You must log in as a user with the Configure Server Basic privilege.
  2. Right-click the project that you want to monitor and select Project Configuration.

    If you are using single instance session logging, the project that you select to configure must be the project that you selected when you set up single instance session logging.

  3. Expand the Database Instances category, and select the SQL Data warehouses subcategory.

  4. You need to create a new database instance for the statistics repository database. Click New.

  5. In the Database instance name field, type in a name for the statistics repository database instance.
  6. From the Database connection type drop-down list, select the database type and version that corresponds to the statistics repository database DBMS.
  7. You need to create a new database connection to connect to the database instance. Click New.
  8. In the Database connection name field, type a name for the database connection.
  9. From the ODBC Data Sources list, select the Data Source Name used to connect to the statistics repository database.
  10. Enable parameterized queries in the statistics repository database connection. To do this, on the Advanced tab, select the Use parameterized queries check box.
  11. You need to create a new database login to log in to the database instance. On the General tab, click New.
  12. Type a name for the new database login in the Database login field.

    If this database login is more than 32 characters long, the statistics logging will generate errors in the DSS Errors log.

  13. Type a valid database login ID and password in the corresponding fields.

    MicroStrategy does not validate this login ID and password, so be careful to type them correctly.

  14. Click OK three times to return to the Project Configuration Editor. In each case before clicking OK, make sure your new database login and database connection are selected.
  15. In the Database Instances category, select the Statistics subcategory.
  16. From the Statistics database instance drop-down list, select your new statistics database instance.
  17. Click OK.

Configure an Additional Database Driver Setting

If your statistics and Enterprise Manager repository is in an Oracle, Sybase, or Teradata database, you must configure an additional ODBC driver setting so the information is recorded properly in the statistics repository.

  1. Open the ODBC Data Source Administrator tool in Windows.
  2. Select the DSN for your statistics and Enterprise Manager repository and click Modify.
  3. Perform the following according to your database:
    • Oracle: click the Advanced tab and select the Enable SQLDescribeParam checkbox.
    • Sybase: click the Advanced tab and select the Enable Describe Parameter checkbox.
    • Teradata: click Options and select the Enable Extended Statement Information checkbox.
  4. Click OK twice.

Specifying Which Statistics to Log

Once you have specified a statistics database instance for a project, you can select what statistics to log. For detailed information about what statistics can be logged, see Overview of Intelligence Server Statistics.

You must specify what statistics to log for all projects that log statistics. Single instance session logging (see Overview of Intelligence Server Statistics) causes all projects on a project source to share the same statistics database, but not to log the same statistics.

To log information from performance counters, use the Diagnostics and Performance Logging Tool. For steps on how to log performance information, see Overview of Intelligence Server Statistics.

To Specify Which Statistics to Log

  1. In Developer, log in to the project source containing the project for which you want to log statistics. You must log in as a user with the Configure Server Basic privilege.
  2. Right-click the project that you want to monitor and select Project Configuration.
  3. Expand the Statistics category, and select the General subcategory.
  4. Select the Basic Statistics checkbox.
  5. To log advanced statistics, select the checkboxes for the statistics you want to log. For information about each check box, see Overview of Intelligence Server Statistics.
  6. Click OK.
  7. To begin logging statistics, unload and reload the project for which you are logging statistics:
    1. In Developer, expand Administration, then expand System Administration, then select Project.
    2. Right-click the project, point to Administer Project, and select Unload.
    3. Right-click the project, point to Administer Project, and select Load.