MicroStrategy ONE

Platform Analytics

Upgrade the Platform Analytics Project

As of 2019, you can upgrade your Platform Analytics project in the metadata of your connected Intelligence Server. Upgrading the project is recommended with each platform and update release in order to brings in the latest dashboards, attributes, metrics and reporting optimizations to the Platform Analytics project.

  1. Open Configuration Wizard.
  2. Select Upgrade existing environment to MicroStrategy Secure Enterprise, and click Next.

  3. Select Upgrade Platform Analytics Project, and click Next.

  4. Provide the following information:
    • User Name: Enter the MicroStrategy user name that can access the Intelligence Server.

      If this is your first time connecting to the MicroStrategy Intelligence Server, use the user name Administrator without a password.

    • Password: Enter the password for the MicroStrategy user that can access the Intelligence Server.

  5. Select the MySQL/PostgreSQL DSN for the Platform Analytics Repository.

  6. Enter your User Name and Password for the DSN.
  7. Click Next.

  8. Click Apply. The Configuration Wizard automatically applies one of the following configuration files depending on the status of the user.

    For new MySQL users:

    • PlatformAnalyticsConfigurationNew.scp

    For existing MySQL users:

    • PlatformAnalyticsConfigurationUpgrade.scp

    For new MicroStrategy users:

    • PlatformAnalyticsConfigurationNew_PostgreSQL.scp

    For existing PostgreSQL users:

    • PlatformAnalyticsConfigurationUpgrade_PostgreSQL.scp
  9. To manually update the project settings, see Configure the Platform Analytics Project.

Upgrade the Platform Analytics Repository

Upgrading the repository is required with each platform and update release in order to benefit from Platform Analytics warehouse new features, defect fixes, and database structure optimizations.

The Configuration Wizard provides the following options:

  • Host: Type the host name of the Platform Analytics warehouse. By default, this is set to the last successful connection value.
  • Port: Type the port number of the Platform Analytics warehouse. By default, this is set to the last successful connection value.
  • User Name: Type the user name for the Platform Analytics warehouse. By default, this is set to the value from PAConsumerConfig.yaml file
  • Password: Type the password for the Platform Analytics warehouse user.

Depending on the warehouse type you choose for the Host and Port, you must set the parameter whDbType to either "postgresql" or "mysql" in the PAConsumerConfig.yaml file.

The default path is:

  • Linux: /opt/MicroStrategy/PlatformAnalytics/Conf
  • Windows: C:\Program Files (x86)\MicroStrategy\Platform Analytics\conf

Click Next to proceed.

You can also update the Platform Analytics repository using the Configuration Wizard in interactive mode.

How to Update the Repository in Interactive Mode

  • Windows
  • Linux
  1. In a Windows console, enter one of the following commands:
    • For 64-bit, enter MACfgWiz_64.
    • For 32-bit, enter MACfgWiz.
  2. Click Enter.

  3. Type 2 and click Enter to create a new response.ini file.

  4. Type 5 and click Enter to upgrade your existing environment to MicroStrategy Analytics Enterprise.

  5. Type 3 and click Enter to upgrade your Platform Analytics repository.
  6. Enter your Platform Analytics warehouse database credentials. By default, the server name, port number, and user name are set to the last successful connection value.

    If you did not change the values, leave as default. The default password can be found at C:\Program Files (x86)\Common Files\MicroStrategy\Default_Accounts.txt

  7. By default, the configuration is saved as Response.ini in the common files path, C:\Program Files (x86)\Common Files\MicroStrategy. 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.
  8. Type Y and click Enter to run the configuration.
  1. In a Linux console window, browse to HOME_PATH where HOME_PATH is the specified home directory during installation.
  2. Browse to the bin directory.
  3. At the command prompt, type mstrcfgwiz-editor, then click Enter. The Configuration Wizard opens in command line mode.
  4. Click Enter.

  5. Type 2 and click Enter to create a new response.ini file.

  6. Type 5 and click Enter to upgrade your existing environment to MicroStrategy Analytics Enterprise.

  7. Type 3 and click Enter to upgrade your Platform Analytics repository.

  8. Enter your Platform Analytics warehouse database credentials. By default, the server name, port number, and user name are set to the last successful connection value.

  9. 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.

  10. Type Y and click Enter to run the configuration.