MicroStrategy ONE

Install and Configure the MDX Cube Provider and TM1 OLEDB Provider

  1. Install the MicroStrategy MDX Cube Provider on a machine. For information on how to install this component, which is provided with MicroStrategy, see the Installation and Configuration Help.

  2. Install the TM1 OLEDB Provider on the machine where you installed MicroStrategy and the MicroStrategy MDX Cube Provider. For 32-bit operating systems, install the 32-bit TM1 OLEDB Provider, and for 64-bit operating systems, install the 64-bit TM1 OLEDB Provider.

    For information on how to install the TM1 OLEDB Provider, see your third-party TM1 documentation.

  3. In the installation location for the MicroStrategy MDX Cube Provider, you must modify the Datasources.xml file. It is recommended that you make a backup copy before modifying this .xml file.

    • In the Datasources.xml file, locate the <AuthenticationMode></AuthenticationMode> section. Within this section, type the authentication mode used for the virtual directory running on Microsoft Internet Information Services. You can use either Basic or Integrated authentication. For information on these authentication options, refer to your third-party Microsoft documentation.

    • In the Datasources.xml file, locate the <ProgramID></ProgramID> section. Within this section, type the value TM1OLAP.

      The Datasources.xml file includes an example definition for the <DataSources></DataSources> section with default values for a TM1 connection. You can use this section as a template for the <DataSources> definition of your TM1 connection.

  4. Create a database instance in MicroStrategy that connects to your TM1 server. Creating a database instance and its components requires a MicroStrategy login with administrative privileges:

    • Create a database connection with all valid TM1 connection information, including the URL of the MicroStrategy MDX Cube Provider and the TM1 server configuration.
    • Create a database login used to connect to your TM1 server.

Upon completing the installations, see Creating a Database Instance for TM1 Servers for next steps.