MicroStrategy ONE

Response Configuration Parameters and Options

MicroStrategy recommends that you always create the response file through the GUI mode of the Configuration Wizard. However, you can also modify a response file with a text editor to make minor changes such as entering different user login and password information.

If you are manually editing the response file, make sure to save the file using ANSI encoding.

Upgrading Intelligence Server Components and Projects

The response file parameters in the [UpgradeServer] section upgrade Intelligence Server components and projects. The table below lists the available parameters and the functionality of available options for each parameter. The options marked with Removed from 11.3.1 are ignored in the Configuration Wizard when upgrading Intelligence Server components using 11.3.1 and above.

Options

Description

[UpgradeServer]

In this section you can upgrade Intelligence Server components and the projects for an Intelligence Server.

UpgradeServer=

Defines whether to upgrade Intelligence Server components and projects, as determined by the following values:

1: Upgrade Intelligence Server components and projects.

0: Does not upgrade Intelligence Server components and projects.

UpgradeMD=

Defines whether to upgrade the metadata, as determined by the following values:

1: Upgrades the metadata repository, which contains the definitions of your MicroStrategy applications and supporting objects. An upgrade of your metadata is required to provide support for all new and updated features in the most recent version of MicroStrategy.

0: Does not upgrade the metadata.

Upgrade Privileges=

Removed from 11.3.1

Defines whether to upgrade administrative privileges, as determined by the following values:

1: Upgrades the privileges used to define the features and capabilities available for each MicroStrategy user. This upgrade is required to reflect any changes in privileges for the most recent version of MicroStrategy. After the upgrade is finished, you can manually modify the privileges for your users and user groups to ensure that all users have access to the required MicroStrategy features. To ensure that the updated user privileges are in compliance with your license agreement, you can use License Manager to audit and view user product privileges.

0: Does not upgrade administrative privileges.

MigrateHL=

Defines whether to migrate History List from a flat file to a database, as determined by the following values:

1: Migrates your previous file-based History List repository to a database-based History List repository. In pre-9.0 versions of MicroStrategy, all History List files were stored using a file-based method. In addition to the file-based method, it is also possible to store the History List repository in the database. This allows administrators to centrally monitor all History List messages across the system.

0: Does not migrate History Lists to a database. Use this option if you did not previously use History List messages or you plan to continue to use a flat file to support and store History Lists.

UpgradeProjects=

Defines whether to upgrade projects, as determined by the following values:

1: Upgrades the projects defined in ProjectLogicalUpgrade.

0: Does not upgrade projects.

ServerUser=

Provide the user name for the MicroStrategy user to connect to the Intelligence Server to upgrade.

ServerPwd=

Provide the password for the MicroStrategy user to connect to the Intelligence Server to upgrade.

MDPwd=

Provide the password for the metadata to upgrade.

PrivilegesSource
Version=

Removed from 11.3.1

If you have previously upgraded the metadata but not upgraded the privileges, provide the version of the metadata that you most recently upgraded your privileges to, from the following list of options:

9.4

9.5

9.5.1

10

10.1

10.2

10.3

10.4

10.5

10.6

10.7

10.8

10.9

10.10

10.11

HLTarget=

If performing a History List migration, the type of History List to migrate to:

File

Database

Hybrid

HLPath=

If performing a History List migration, defines the directory location of the History List flat file to migrate to a database.

HybridPath=

If performing a History List migration to a hybrid History List, defines the directory location where the hybrid History List files are to be stored.

HLDSNName=

If performing a History List migration, defines the DSN of the database to migrate the History List tables to.

HLUserName=

If performing a History List migration, defines the user name to connect to the database for the History List migration.

HLUserPwd=

If performing a History List migration, defines the password to connect to the database for the History List migration.

HLPrefix=

If performing a History List migration, defines the table prefix for History List tables.

HLDropTables=

Defines whether to drop existing tables in the database used for the History List migration, as determined by the following values:

1: Deletes existing tables in the database before migrating the History List tables.

0: Appends the migrated History List tables to the database without deleting existing tables.

HLDeleteFiles=

Defines whether to delete the file based History List after the migration is complete, as determined by the following values:

1: Deletes the file-based History List repository once the migration to a database-based History List repository is complete. This option should only be used if the file-based History List repository is no longer needed, and you can ensure the migration process can be completed successfully.

0: Does not delete the file-based History List repository once the migration to a database-based History List repository is complete.

HLUseUTF8=

Defines whether UTF-8 encoding should be used for the History List migration on Windows, as determined by the following values:

1: Uses UTF-8 encoding for Windows drivers. This option should be used if your database and History List messages use UTF-8 encoding, and the Intelligence Server is installed on Windows.

0: Does not use UTF-8 encoding.

HLUseUNIXUTF8=

Defines whether UTF-8 encoding should be used for the History List migration on UNIX/Linux, as determined by the following values:

1: Uses UTF-8 encoding for UNIX/Linux drivers. This option should be used if your database and History List messages use UTF-8 encoding, and the Intelligence Server is installed on UNIX or Linux.

0: Does not use UTF-8 encoding.

HLDB2zOSDBName=

Defines the database name to create or migrate History Lists stored in DB2 z/OS. This option should be used if connecting to a DB2 z/OS database.

HLDB2zOSTableSpaceName=

Defines the table name to be used in the database when creating or migrating the History List. This option should be used if connecting to a DB2 z/OS database.

ThreadNumber

If performing a History List repository upgrade to a hybrid History List, defines the number of database threads to use for the upgrade.

ProjectLogicalUpgrade=

Defines the projects to update their schedules that send reports and documents to caches, History Lists, and MicroStrategy Mobile as subscriptions. These subscriptions are part of the integrated subscription and delivery features in Intelligence Server 9.0 and later versions. They provide the same ability to send reports and documents to caches, History Lists, and MicroStrategy Mobile as the schedules in MicroStrategy pre-9.0.

This option also upgrades the reports and Report Services documents in the projects, which improves performance, reduces storage space requirements, and ensures that graphs display correctly in MicroStrategy Web 10 and Developer 10.

To upgrade multiple projects, you must enclose the name of each project in curly braces {} and separate the names with a backslash \ . For example:

{Project1}\{Project2}\...\{ProjectN}

ScheduleUpdate=

Removed from 11.3.1

Defines the projects to upgrade their schedules to the most recent version of MicroStrategy.

To upgrade multiple projects' schedules, you must enclose the name of each project in curly braces { } and separate the names with a backslash \ . For example:

{Project1}\{Project2}\...\{ProjectN}

MDXUpdate=

Removed from 11.3.1

Defines the projects to update their MDX source objects (MDX cubes) that were created in earlier versions of MicroStrategy to take advantage of increased performance and other updates.

You can integrate MDX sources such as SAP BW, Microsoft Analysis Services, and Hyperion Essbase into your MicroStrategy environment. For information on integrating MDX sources into MicroStrategy, see the MDX Cube Reporting Guide.

To upgrade multiple projects' MDX source objects, you must enclose the name of each project in curly braces { } and separate the names with a backslash \ . For example:

{Project1}\{Project2}\...\{ProjectN}

SysObjIDUnification=

Defines the projects for which to update system objects so that objects can be moved between unrelated projects using MicroStrategy Object Manager. This is required for projects from pre-9.0.1 versions of MicroStrategy.

To upgrade multiple projects' system objects, you must enclose the name of each project in curly braces { } and separate the names with a backslash \ . For example:

{Project1}\{Project2}\...\{ProjectN}

ProjectUpgradeContinueExecuting=

Defines whether to update the rest of the specified projects if one project update generates an error:

1: Continues the update process even if an error is found in one project.

0: Halts the update process for all projects if an error is found in one project.

EncryptPassword=

Defines whether the password is encrypted in the response file, as determined by the following values:

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

0: The password is not encrypted in the response file, which enables you to modify the password in the response file later 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 password from the response file before distributing it.

DB2ZoSDBName=

Defines the database name to update metadatas stored in DB2 z/OS. This option should be used if connecting to a DB2 z/OS database.

DB2ZoSTableSpaceName=

Defines the table name to be used in the database when upgrading the metadata. This option should be used if connecting to a DB2 z/OS database.

LeanObjects=

Removed from 11.3.1

Defines whether to perform Lean Objects migration at the server level:

1: Perform Lean Objects migration.

0: Do not perform Lean Objects migration.

LeanObjectsProjects=

Removed from 11.3.1

Defines whether to perform Lean Objects migration at the project level:

1: Perform Lean Objects migration.

0: Do not perform Lean Objects migration.

Upgrading Statistics Repositories

The response file parameters in the [UpgradeStats] section upgrade statistics and Enterprise Manager repositories. The table below lists the available parameters and the functionality of available options for each parameter.

Options

Description

[UpgradeStats]

In this section you can upgrade statistics repositories to the most recent version of MicroStrategy. You can have more than one [UpgradeStats] section. Additional statistics upgrade sections can be included as [UpgradeStats1], [UpgradeStats2], and so on.

UpgradeStats=

Defines whether to upgrade the statistics and Enterprise Manager repositories, as determined by the following values:

1: Upgrades the statistics repository

0: Does not upgrade the statistics repository

EncryptPassword=

Defines whether the password is encrypted in the response file, as determined by the following values:

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

0: The password is not encrypted in the response file, which enables you to modify the password in the response file later 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 password from the response file before distributing it.

StatsDSN=

If performing a statistics repository upgrade, defines the DSN of the database that stores the statistics repository.

StatsUser=

If performing a statistics repository upgrade, defines the user name to connect to the database for the statistics repository.

StatsPwd=

If performing a statistics repository upgrade, defines the password to connect to the database for the statistics repository.

StatsPrefix=

If performing a statistics repository upgrade, defines the database prefix for the statistics repository.

Upgrading an Enterprise Manager Project

The response file parameters in the [EMProjectHeader] section upgrade an Enterprise Manager project. The table below lists the available parameters and the functionality of available options for each parameter.

Options

Description

[EMProjectHeader]

In this section you can upgrade an Enterprise Manager project to the most recent version of MicroStrategy. You can have more than one [EMProjectHeader] section. Additional Enterprise Manager project upgrade sections can be included as [EMProjectHeader1], [EMProjectHeader2], and so on.

EMProject=

Defines whether to upgrade the Enterprise Manager project, as determined by the following values:

1: Upgrades the Enterprise Manager project.

0: Does not upgrade the Enterprise Manager project.

EMProjectEncryptPwd=

Defines whether the password is encrypted in the response file, as determined by the following values:

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

0: The password is not encrypted in the response file, which enables you to modify the password in the response file later 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 password from the response file before distributing it.

EMProjectDSSUser=

If performing an Enterprise Manager project upgrade, provides the MicroStrategy user name that can access and administer the Enterprise Manager project.

EMProjectDSSPwd=

If performing an Enterprise Manager project upgrade, provides the password for the MicroStrategy user that can access and administer the Enterprise Manager

project.

EMProjectDSNName=

If performing an Enterprise Manager project upgrade, defines the DSN of the database that stores the statistics tables and Enterprise Manager repository.

EMProjectDSNUserName=

If performing an Enterprise Manager project upgrade, defines the user name to connect to the database for the statistics tables and Enterprise Manager repository.

EMProjectDSNUserPwd=

If performing an Enterprise Manager project upgrade, defines the password to connect to the database for the statistics tables and Enterprise Manager repository.

EMProjectDSNPrefix=

If performing an Enterprise Manager project upgrade, defines the database prefix for the statistics tables and Enterprise Manager repository.

Upgrading History List Repositories

The response file parameters in the [UpgradeHistoryList] section upgrade a database-based History List repository. The table below lists the available parameters and the functionality of available options for each parameter.

Options

Description

[UpgradeHistory
List]

In this section you can upgrade History List repositories to the most recent version of MicroStrategy. You can have more than one [UpgradeHistoryList] section. Additional History List upgrade sections can be included as [UpgradeHistoryList1], [UpgradeHistoryList2], and so on.

UpgradeHistory
List=

Defines whether to upgrade a History List repository, as determined by the following values:

1: Upgrades the History List repository.

0: Does not upgrade the History List repository.

EncryptPassword=

Defines whether the password is encrypted in the response file, as determined by the following values:

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

0: The password is not encrypted in the response file, which enables you to modify the password in the response file later 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 password from the response file before distributing it.

HLDSN=

If performing a History List repository upgrade, defines the DSN of the database that stores the History List repository.

HLUser=

If performing a History List repository upgrade, defines the user name to connect to the database for the History List repository.

HLPwd=

If performing a History List repository upgrade, defines the password to connect to the database for the History List repository.

HLPrefix=

If performing a History List repository upgrade, defines the database prefix for the History List repository.

CopyContent=

If performing a History List repository upgrade, upgrades existing History List messages to the specified format, as determined by the following values:

1: Upgrades existing History List messages.

0: Does not upgrade existing History List messages.

Regardless of this setting, the new database tables required for the new History List format are created, and any new History List messages are created in the new format.

CompressData=

If performing a History List repository upgrade, compresses all existing History List messages, as determined by the following values:

1: Compresses existing History List messages.

0: Does not compress existing History List messages. Newly created messages are compressed.

Migrating Web Delivery Subscriptions from Narrowcast Server to MicroStrategy Distribution Services

The response file parameters in the [UpgradeServer] section migrate MicroStrategy Web delivery subscriptions from a Narrowcast Server environment to Distribution Services. MicroStrategy Web delivery subscriptions include email, file, and print subscriptions created from MicroStrategy Web. Migrating these subscriptions from Narrowcast Server to Distribution Services allows the subscriptions to be centralized in Intelligence Server rather than a separate Narrowcast Server. The table below lists the available parameters and the functionality of available options for each parameter.

Options

Description

[MigrateNCS]

In this section you can migrate MicroStrategy Web delivery subscriptions from a Narrowcast Server environment to Distribution Services. You can have more than one [MigrateNCS] section. Additional MicroStrategy Web delivery subscription migration sections can be included as [MigrateNCS1], [MigrateNCS2], and so on.

MigrateNCS=

Defines whether to migrate MicroStrategy Web delivery subscriptions from a Narrowcast Server environment to Distribution Services, as determined by the following values:

1: Migrates MicroStrategy Web delivery subscriptions from a Narrowcast Server environment to Distribution Services.

0: Does not migrate MicroStrategy Web delivery subscriptions from a Narrowcast Server environment to Distribution Services.

DSNNameSBR=

Defines the DSN of the database that stores the Narrowcast Subscription Book Repository.

UserNameSBR=

Defines the user name to connect to the database for the Narrowcast Subscription Book Repository.

UserPwdSBR=

Defines the password to connect to the database for the Narrowcast Subscription Book Repository.

SysPrefixSBR=

Defines the prefix used for the tables of the Narrowcast Subscription Book Repository.

DSNNameOR=

Defines the DSN of the database that stores the Narrowcast Object Repository.

UserNameOR=

Defines the user name to connect to the database for the Narrowcast Object Repository.

UserPwdOR=

Defines the password to connect to the database for the Narrowcast Object Repository.

SysPrefixOR=

Defines the prefix used for the tables of the Narrowcast Object Repository.

PSNName=

Defines the project source that the Web delivery subscriptions are migrated to.

DSSUser=

Defines the user name to connect to the project source.

DSSPwd=

Defines the user password to connect to the project source.

TargetProjects=

Defines the projects, for a project source, to migrate Web subscriptions from Narrowcast Server to Distribution Services. You can select multiple projects, separating projects by the \ character. For example, TargetProjects=Project1\Project2.

MigrateWeb
DeliveryUsers=

Defines whether to migrate all users of Web deliveries to Distribution Services, as determined by the following values:

1: Migrates all users of Web deliveries to Distribution Services. Addresses of the MicroStrategy users who subscribed to Web deliveries are assigned to the corresponding MicroStrategy users. No new MicroStrategy users are created.

0: Does not migrate all users of Web deliveries to Distribution Services.

Assign
Privileges=

If you choose to migrate all users of Web deliveries to Distribution Services, this option defines whether to grant the Use Distribution Services privilege for all Web delivery users that are migrated to Distribution Services, as determined by the following values:

1: Grants the Use Distribution Services privilege for all Web delivery users that are migrated to Distribution Services. Ensure that granting these privileges is in compliance with your product license for Distribution Services.

0: Does not grant the Use Distribution Services privilege for all Web delivery users that are migrated to Distribution Services.

MigrateNCSUsers=

Defines whether to migrate Narrowcast Server users and their addresses as contacts in Distribution Services, as determined by the following values:

1: Migrates Narrowcast Server users and their addresses as contacts in Distribution Services. A contact is created for each Narrowcast Server user. The Narrowcast Server user's addresses are copied as addresses of the contact. A contact is a list of subscription recipient addresses. These recipients do not have the permissions to log in to MicroStrategy Web or Developer. Contacts enable these recipients to receive subscriptions.

0: Does not migrate Narrowcast Server users and their addresses as contacts in Distribution Services

MigrateTransmittersAction=

These parameters specify the conflict resolution rules when migrating Narrowcast objects to Distribution Services. Conflicts occur when identical objects are present in both the Narrowcast Server system you are migrating from and the Intelligence Server metadata you are migrating to. Defining conflict resolution rules determines how these conflicts are resolved during the migration.

You can use the following parameters to define how to resolve any conflicts during the migration:

MigrateTransmittersAction for Transmitters

MigrateDevicesAction for Devices

MigrateSchedulesAction for Schedules

MigrateSubscriptionsAction for Subscriptions

MigrateUsersAction for Users

For each object type listed above, you can define conflict resolution rules based on matching IDs. For transmitters, devices, and schedules you can also define conflict resolution rules based on matching definitions. These options are described in the table below.

In the table below, "source" refers to your Narrowcast Server and "destination" refers to the new metadata tables.

MigrateDevicesAction=

MigrateSchedulesAction=

MigrateSubscriptionsAction=

MigrateUsersAction=

Match by ID or Definition

Conflict Resolution

Option Value

Match by IDs

Objects are matched by their ID only.

Match by IDs, keep existing

If objects with matching IDs are found, the object in the destination location is kept. The object in the source is not migrated to the destination.

1

Match by IDs, replace

If objects with matching IDs are found, the object from the source replaces the matching object in the destination.

2

Match by Definition

Objects are matched by their definitions. This enables objects that have the same definition, but different IDs to be defined as a match. These conflict resolution options are available for transmitters, devices, and schedules.

Match by Definition, merge

If objects with matching definitions are found, all dependent objects of the matching object in the source are migrated to the destination. The migrated dependent objects are defined as dependents of the matching object in the destination.

3

Match by Definition, create new

If objects with matching definitions are found, the matching object in the source is migrated to the destination as a new object. A separate object for the matching object in the destination is also kept. This results in two objects with matching definitions in the destination, which you can modify after the migration is complete.

4

EncryptPassword=

Defines whether the password is encrypted in the response file, as determined by the following values:

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

0: The password is not encrypted in the response file, which enables you to modify the password in the response file later 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 password from the response file before distributing it.