MicroStrategy ONE

Creating a Project Using a Response File

As an alternative to creating a project using a response file, you can create a response file with the Platform Analytics project information and use that response file with the Configuration Wizard to automatically create the Platform Analytics project on your Intelligence server and configure the connection to the Platform Analytics repository.

Creating a Response File

MicroStrategy recommends that you create a response file through the graphical interface of the Configuration Wizard. You step through the Configuration Wizard and make your selections, as described in Creating the Platform Analytics project. When you reach the Summary page of the Configuration Wizard, do not click Finish. Instead, click Save. You are prompted to save your selections in a response file.

You can also create or modify a response file with a text editor. For information on all the parameters in the response file, see Platform Analytics Response File Parameters.

MicroStrategy supplies a blank response file template, Response.ini, in the Common Files folder of your MicroStrategy installation. By default, this folder is C:\Program Files (x86)\Common Files\MicroStrategy.

Platform Analytics Response File Parameters

The table below lists the available parameters and the functionality of available options for each parameter.

Options

Description

[PAProjectHeader] Options in this portion refer to creating the Platform Analytics project on this machine.
PAProject=

Defines whether to create the Platform Analytics project, as determined by the following values:

  • 1: Create Platform Analytics project on this machine.
  • 0: Do not create the Platform Analytics project.

PAProjectEncryptPwd=

Defines whether the passwords are encrypted in the response file, as determined by the following values:

  • 0: The passwords are not encrypted in the response file, which enables you to modify the passwords in the response file using a text editor. You can then distribute the response file to multiple users with various login and password credentials. However, be aware that this can compromise your database security if you do not remove the passwords from the response file before distributing it.

  • 1: Encrypts the passwords in the response file, which ensures that your passwords are secure. This is the default behavior.

PAProjectDSSUser= The user name to log in to the Platform Analytics project.

PAProjectDSSPwd=

The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting.

PAProjectPkgFile=

Beginning with MicroStrategy 2020, this file will be removed and the default project package will be used.

The full path and file name of the MicroStrategy Platform Analytics project package file used to create the project.

On Windows, by default this is C:\Program Files (x86)\Common Files\MicroStrategy\PlatformAnalyticsProjectObjects.mmp

PAConfigurePkgFile=

Beginning with MicroStrategy 2020, this file will be removed and the default project package will be used.

The full path and file name of the MicroStrategy Platform Analytics project configuration package file used to create the project.

On Windows, by default this is C:\Program Files (x86)\Common Files\MicroStrategy\PlatformAnalyticsConfigurationObjects.mmp.

PAProjectDSNName= The Data Source Name for the database that contains your Platform Analytics repository.

PAProjectDSNUserName=

The user name to connect to the Platform Analytics repository database.

PAProjectDSNUserPwd= The password for the user name above for the Platform Analytics repository database. This may be encrypted, depending on the PAProjectEncryptPwd= setting.

PAProjectDSNPrefix=

The prefix for the Platform Analytics repository tables.

Example

Using the above parameters, this is an example of a completed response file.

Copy
[PAProjectHeader]
PAProject=1
PAProjectEncryptPwd=1
PAProjectDSSUser=Administrator
PAProjectDSSPwd=password
PAProjectDSNName=PA_WAREHOUSE
PAProjectDSNUserName=root
PAProjectDSNUserPwd=password
PAProjectDSNPrefix=

Executing a Response File

You can execute a response file in any of the following ways:

To Use a Response File with the Configuration Wizard

  1. From the Windows Start menu choose All Programs > MicroStrategy Tools > Configuration Wizard.
  2. Click Load.
  3. Browse to the path where the response file is saved and click Open.
  4. An overview of all the configuration tasks performed by the response file is displayed. Review the tasks and click Finish.

To Use a Response File through the Windows Command Line

Enter the following command in the Windows command line:

Copy
macfgwiz.exe -r "Path\response.ini"

Where Path\ is the fully qualified path to the response file.

For example, a common location of a response file is:

C:\Program Files (x86)\Common Files\MicroStrategy\RESPONSE.INI

If an error message is displayed, check the path and name you supplied for the response file and make any required changes.

To Use a Response File through the Configuration Wizard in UNIX or Linux

From a UNIX or Linux console window:

  1. Browse to <HOME_PATH> where <HOME_PATH> is the directory you specified as the Home Directory during installation.
  2. Browse to the folder bin.
  3. Enter mstrcfgwiz-editor and press Enter.
  4. Press Enter on the Configuration Wizard Welcome page.
  5. Type 1 to use a response file and press Enter.
  6. Type the fully qualified path to the response.ini file and press Enter.

    For example:

    /home/username/MicroStrategy/RESPONSE.INI

If an error message is displayed, check the path and name you supplied for the response file and make any required changes.

To Use a Response File through the UNIX/Linux Command Line

  1. From a UNIX or Linux console window, browse to <HOME_PATH> where <HOME_PATH> is the directory you specified as the Home Directory during installation.
  2. Browse to the folder bin.
  3. Enter the following command in the command line and press Enter.

    Copy
    mstrcfgwiz-editor -response /Path/response.ini

    Where Path is the fully qualified path to the response file.

    For example, a common location of a response file is:

    /home/username/MicroStrategy/RESPONSE.INI

If an error message is displayed, check the path and name you supplied for the response file and make any required changes.