MicroStrategy ONE

Setting Up the MicroStrategy Intelligence Server

If you selected option 2 in Creating a response.ini File, you can set up MicroStrategy Intelligence Server to create, use, or delete server definitions. To begin setting up your server definition, you must enter information about your ODBC DSN and MicroStrategy connections.

To Set Up the MicroStrategy Intelligence Server

  1. Type the corresponding number for the ODBC DSN for a database to connect Intelligence Server to. This should be the data source that stores your metadata. Click Enter. You are then prompted to provide a login to your DSN.
  2. Type a login name for your database to create your statistics tables in and click Enter. You are then prompted to provide a password for the login name.
  3. Type a password for the login name provided and click Enter. You are then prompted to provide a metadata prefix.
  4. You can enter characters to use as a prefix for the names of your metadata tables or use no prefix, as described below:
    • Type the required prefix characters and click Enter.

    • Leave the prompt blank and click Enter to provide no metadata prefix.

    You are then prompted to provide a temp table prefix.

  5. You can enter characters to use as a prefix for the names of temp tables or use no prefix, as described below:
    • Type the required prefix characters and click Enter.
    • Leave the prompt blank and click Enter to provide no temp table prefix.

    You are then prompted to provide a MicroStrategy user login.

  6. Type a valid MicroStrategy user login that has administrator privileges and click Enter.You are then prompted to provide a password for the login name.

    The default administrator account is Administrator with a blank password. This should be changed after you initial configuration.

  7. Type a password for the MicroStrategy user login provided and click Enter. You are then prompted to choose the type of Intelligence Server configuration to complete.
  8. You can perform one of the Intelligence Server configuration tasks, which are described in the sections below:
    • Type 1 and click Enter to create a new server definition. Refer to Creating and Using a Server Definition for steps to create a new server definition.
    • Type 2 and click Enter to use an exiting server definition. This configuration follows the same steps for creating a new server definition, which are described in Creating and Using a Server Definition.
    • Type 3 and click Enter to delete a server definition. Refer to Deleting a Server Definition for steps to delete a server definition.
    • Type 4 and click Enter to create a new server definition and use it as the default server definition. This configuration follows the same steps for creating a new server definition, which are described in Creating and Using a Server Definition.

Creating and Using a Server Definition

You perform the same steps to complete the following actions:

  • Create a new server definition
  • Create a new server definition and use it as the default server definition
  • Use an existing server definition.

The action taken depends on what action you selected to complete in the procedure To Set Up the MicroStrategy Intelligence Server.

This procedure assumes you have already opened the Configuration Wizard in command line mode and entered configuration information for your Intelligence Server, as described in To Set Up the MicroStrategy Intelligence Server.

To Create and Use a Server Definition

  1. In the prompt that asks for a server definition name, type the name that distinguishes the server definition and click Enter. You can click Enter without entering any information to use the default server definition. You are then prompted to choose the projects to load for the server definition.
  2. Type the names of projects to load when the server definition starts and click Enter. Separate the project names with the \ character. You are then prompted to choose projects to not load for the server definition.
  3. Type the names of projects to not load when the server definition starts and click Enter. Separate the project names with the \ character. You are then prompted to provide a TCP port to use for Intelligence Server.
  4. You can use the default port number or enter a different port number for Intelligence Server, as described below:
    • Leave the prompt blank and click Enter to use the default port number.
    • Type a port number and click Enter.

    You are then prompted whether to register Intelligence Server as a service.

  5. You can choose whether to register Intelligence Server as a service, as described below:
    • Type Y and click Enter to register Intelligence Server as a service. To perform this configuration, you must be logged into your Linux machine with an account that has root level access and permissions.
    • Type N and click Enter to not register Intelligence Server as a service.

    You are then prompted whether to start Intelligence Server when finished

  6. Type Y and click Enter to start Intelligence Server after the response file is executed. You are then prompted to provide a name for the response.ini file.

To Generate a Response.ini File

  1. By default, the configuration is saved as Response.ini in the /HOME_PATH/ directory, where HOME_PATH is the directory you specified as the Home Directory during installation. You can leave the field blank to use the default name or type a different name, and then click Enter. The response.ini file is generated, and you are prompted whether to run the configuration immediately.
  2. You can choose to run the configuration you just completed or to run the configuration using the response.ini file at a different time, as described below:

Deleting a Server Definition

This procedure assumes you have already opened the Configuration Wizard in command line mode and entered configuration information for your Intelligence Server, as described in To Set Up the MicroStrategy Intelligence Server.

In the prompt that asks for server definitions to be removed, type the name that distinguishes the server definition and click Enter. You can list multiple server definitions to be deleted, separating server definition names with the \ character. You are then prompted to provide a name for the response.ini file.

  1. Type the name that distinguishes the server definition in the prompt that asks for server definitions to be removed. Click Enter.

    You can list multiple server definitions to be deleted, separating server definition names with the \ character.

  2. Name the response.ini file.

To Generate a response.ini File

  1. By default, the configuration is saved as Response.ini in the /HOME_PATH/ directory, where HOME_PATH is the directory you specified as the Home Directory during installation. You can leave the field blank to use the default name or type a different name and click Enter. The response.ini file is generated, and you are prompted whether to run the configuration immediately.
  2. You can choose to run the configuration you just completed or to run the configuration using the response.ini file at a different time, as described below: