Skip to main content

1E 9.x (on-premises)

SLA Business Intelligence installer properties

A table of the Windows installer properties for the SLA Business Intelligence installer. Business Intelligence is only required by the Patch Success application.

Warning

1E Server Setup is the only supported method of installing, upgrading, and patching a 1E server.

Installation using standalone msi or msp files is not supported unless advised by 1E, which may be necessary in complex installations, using non-interactive (quiet/silent) command-lines, and may require further post-install configuration steps.

Note

Mandatory properties must be provided when installing using a command-line.

The installer file is: SLA.BI.Installer.msi

BI_DATABASE_DROPDB | BI_DATABASE_NAME | BI_DATABASE_PASSWORD | BI_DATABASE_SERVER | BI_DATABASE_USEINTEGRATEDSECURITY | BI_DATABASE_USERNAME | COMMON_DATABASE_NAME | SSAS_DATABASE_DROPDB | SSAS_DATABASE_NAME | SSAS_DATABASE_PASSWORD | SSAS_DATABASE_SERVER | SSAS_DATABASE_USERNAME

Property

Default

Mandatory

Description

BI_DATABASE_DROPDB

0

If set to 1 on the command-line, it drops the SLA-BI database during installation if it exists on the specified SQL Server instance. The default behavior for this property is to not drop the existing database.

Note

Exercise caution when using this option as any existing data will be deleted. Do not use this option if you want to preserve your existing data.

BI_DATABASE_NAME

SLA-BI

The name of the SLA-BI database.

BI_DATABASE_PASSWORD

Depends

If not using integrated security, this property specifies the password for the SQL authentication username specified in BI_DATABASE_USERNAME.

BI_DATABASE_SERVER

Yes

Name of a SQL Server database instance to host the SLA-BI database.

Note

1E Setup prompts for the SQL Server database instance.

BI_DATABASE_USEINTEGRATEDSECURITY

1

Specifies if integrated security is to be used to access BI database. Values are:

  • 0 – false

  • 1– true

If integrated security is used, then BI will use the SLA Platform service account (specifically the 1E SLA Platform Engine service account).

Note

1E Setup uses integrated security, which means BI uses Network Service assuming SLA was installed by 1E Setup.

BI_DATABASE_USERNAME

Depends

If not using integrated security, this property specifies the SQL Login of the BI SQL user:

  • a SQL login must be pre-created in the SQL instance hosting the BI database

  • an identical SQL login must be pre-created in the SQL database instance hosting the SLA Platform databases, if the BI database is hosted on a separate instance

COMMON_DATABASE_NAME

SLA-Shared

The name of the SLA Platform database used by BI.

SSAS_DATABASE_DROPDB

0

If set to 1 on the command-line, it drops the SLA-BI cube during installation if it exists on the specified SQL Server instance. The default behavior for this property is to not drop the existing cube.

Note

Exercise caution when using this option as any existing data will be deleted. Do not use this option if you want to preserve your existing data.

SSAS_DATABASE_NAME

SLA-BI

The name of the SLA-BI cube.

SSAS_DATABASE_PASSWORD

Yes

Password for the Windows account used by the BI API to query the cube.

Note

1E Setup prompts for the password of the SSAS_DATABASE_USERNAME user account.

SSAS_DATABASE_SERVER

Yes

Name of a SSAS database instance to host the SLA-BI cube.

Note

1E Setup prompts for the SSAS instance.

SSAS_DATABASE_USERNAME

Yes

Username for the BI SSAS user domain account. This is used by the BI Multidimensional Expressions (MDX) API on the Master Stack to query the SLA-BI cube.

Note

1E Setup prompts for a domain user account.

In this section: