Install Open iT Analysis Server (Windows)

Software Installation #

Installing Through the Windows Installer Interface #

  1. Double-click the OpeniTAnalysis Server-[architecture].msi installer file to begin.
    A setup wizard will be displayed. Click Next.
  2. Read the License Agreement before accepting the terms. Click Next.
  3. Specify where the Open iT software will be installed. Click Change to specify a different directory and click Ok. Clicking Next without doing any changes will use the default installation path.
    Click Next.
  4. Specify the TCP/IP port number. This option enables access to the Open iT Analysis Server web application. The default value, 80, may also be used.
    Specify the path for a valid Open iT Analysis Server license key. This location may be changed at a later time on the configuration page of the Open iT Analysis Server web interface.
    Click Next.
  5. Specify the Service Account User Name and the password for the account. The user name must include the Active Directory domain. Click Next.
  6. Specify the User Group and Administrator Group. Click Next.
  7. Specify the SQL Server database and instance name where the SQL data warehouse will be created and deployed. Click Browse to look for available SQL Servers on the network.
    Specify the SQL Server Analysis Services database and instance name which will hold the reporting cube.
    Click Next.
  8. Click Install to start the installation process. If a review of the entries is needed, click Back.
  9. The installer will set up all necessary files on the computer.
    After the installation, the View Release Notes option will be automatically selected. This option will
    show a list of updates and fixes included on the installer through a web browser. Deselect this option as needed.
    Click Finish to complete the installation.

Installing Through the Command Line #

  1. Open a command prompt with Administrator level privilege
  2. Execute the following command:
    > msiexec /i [msi_file] /l*v [log_file] [options] INSTALLDIR=$INSTALL_DIR IISPORTNUMBER=[portnumber] LICENSEFILE=[license_file] RUNASUSER=[domain¥user] REPORTERSGROUP=[group_name] ADMINGROUP=[admingroup_name] SQLSERVER=[sqlserver¥instance_name] SQLDATABASE=[database_name] OLAPSERVER=[olapserver_¥instance_name] OLAPDATABASE=[database_name]
    Required:
    /i [msi_file]
    The path of the Windows installer file, OpeniTAnalysis Server-[Architecture].msi.

    /l*v [log_file]
    The path of the installation log file that will be created during installation.

    Options:
    /quiet
    Run the command in silent mode.

    /passive
    Run the command in unattended mode – progress bar only.

    Note: The installer will use the Windows Installer Interface process when the installation option is not specified.

    Properties:
    INSTALLDIR=$INSTALL_DIR
    The path where the Open iT files will be installed. This value is set to C:¥Program Files¥OpeniT¥Analysis Server by default.
    IISPORTNUMBER=[portnumber]
    The TCP/IP port number used by the reporter website. This is set to 80 by default.

    LICENSEFILE=[license_file]
    The path for the Open iT license file.

    RUNASUSER=[domain¥user]
    The User Name including the Active Directory domain used as the service account.

    RUNASPASSWORD=[password]
    The password of the service account.

    REPORTERSGROUP=[group_name]
    The predefined User group with reporting access.

    ADMINGROUP
    The predefined User group with administrative rights.

    SQLSERVER=[sqlserver¥instance_name]
    The SQL Server including the instance name where the SQL database is created.

    SQLDATABASE=[database_name]
    The name of the SQL database.

    OLAPSERVER=[olapserver¥instance_name]
    The OLAP Server including the instance name where the OLAP database is created.

    OLAPDATABASE=[database_name]
    The name of the OLAP database where the OLAP cubes are created.

  3. When using the passive mode, wait until the process bar dialog disappears. When using the quiet mode, verify if the installation is complete by opening the Task Manager and checking in the Details tab if the msiexec process is still running.

Software Installation Verification #

Verify Scheduled Task #

Upon installation, a scheduled task executes the daily processing of the Analysis Server data.
To verify:

  1. Open the Task Scheduler in the machine where Analysis Server is installed.
  2. In the left pane, click Task Scheduler Library.
  3. In the list of tasks, verify that OpeniT.Server.Etl.Console is present and ready.
  4. Under the Security Options of the task, SYSTEM should be indicated in When running the task, use the following user account.

Verify Created Directories and Files #

Go to the $ROOT_DIR of the installation located, by default, in C:¥Program Files¥OpeniT¥Analysis Server and verify that the following directories and files exist:

  • bin ($BIN_DIR) – contains binary files
  • Configuration ($CONFIG_DIR) – contains Core Server configuration
  • Content – contains media files used in the web interface
  • Documentation – contains guides of the Analysis Server
  • fonts – contains fonts used in the web interface
  • HomeItem – contains the items presented in the home page of the web interface
  • Log – contains web interface and data processing log files
  • Portlets – contains the SQL queries and scripts used by specific dashboard portlets
  • Templates – contains the RDL files of the Open iT SSRS Report templates
  • Uploads – contains uploaded files
  • Views – contains web interface files
  • web.config – contains specific configuration for web service
  • Mvc.sitemap – contains the list of tabs present in the web interface; and the users and groups that can access specific tabs
  • OpeniT.Server.Alerts.Service.exe – the application executed to process configured alerts
  • OpeniT.Server.Etl.Console.exe – the application executed to process Analysis Server data
  • OpeniT.Server.Rs.Console.exe – the application executed to configure settings for SQL Server Reporting Services
  • Other configuration files

Verify Website #

Upon installation, a website is created and hosted in Internet Information Services (IIS).
To verify:

  1. Open IIS (Internet Information Services) in the machine with the Open iT Analysis Server installation.
  2. In the Connections Pane, expand the root node and Sites.
  3. Make sure that the Open iT Analysis Server website is present.
  4. Click the Open iT Analysis Server website, and in the dashboard, double click Authentication.
  5. Make sure that Windows Authentication is enabled.

Verify Running Services #

  1. Open the Task Manager.
  2. Click Services..
  3. Verify that the status of Open iT Alerts is Running.

Verify Release Notes Access #

The web interface is not immediately accessible after installation because it requires the creation of databases. To ensure that web pages rendering is successful, try to access the Release Notes.
To verify:

  1. On a browser, go to http(s)://:¥release_note.html.
    • servername – host name of the machine with Open iT Analysis Server installation.
    • port_number – port number used by the web service. This is specified upon Open iT Analysis Server installation and the default value is 80.
  2. Make sure that the Release Notes is successfully rendered.

Post-Installation Configuration #

Create and Deploy SQL Database #

Background processes of the Analysis Server use an SQL Server database. Furthermore, the successful rendering of the web interface requires the creation and deployment of the SQL and OLAP databases.
To create and deploy:

Creating SQL Database on Server #

  1. Open the command prompt and go to the install directory, C:¥Program Files¥OpeniT¥Analysis Server¥.
  2. Run the CreateSql subcommand by using the syntax:
    C:¥Program Files¥OpeniT¥Analysis Server¥>OpeniT.Server.Etl.Console.exe CreateSql
  3. The Console Application will display information messages in the command prompt. Allow the process to finish.

Deploying SQL Database Schema #

  1. Open the command prompt and go to the install directory, C:¥Program Files¥OpeniT¥Analysis Server¥.
  2. Run the DeploySql subcommand by using the syntax:
    C:¥Program Files¥OpeniT¥Analysis Server¥>OpeniT.Server.Etl.Console.exe DeploySql [/version:value] [/trace] [/sap]
    Optional parameters:

    • /version:[migration_version]
      This parameter limits the migration of the database to the specified version. The migration version format is YYYYMMDDHHMMSS.
      Example:
      C:¥Program Files¥OpeniT¥Analysis Server¥>OpeniT.Server.Etl.Console.exe DeploySql /version:20220101143000
    • /trace
      This parameter triggers the command to display SQL statements.
      Example:
      C:¥Program Files¥OpeniT¥Analysis Server¥>OpeniT.Server.Etl.Console.exe DeploySql /trace
    • /sap
      This parameter triggers the command to deploy the database for Optimizer for SAP Licensing.
      Example:
      C:¥Program Files¥OpeniT¥Analysis Server¥>OpeniT.Server.Etl.Console.exe DeploySql /
    • Combine or use optional parameters at the same time to achieve necessary capabilities.
      C:¥Program Files¥OpeniT¥Analysis Server¥>OpeniT.Server.Etl.Console.exe DeploySql /version:20220101143000 /trace

  3. The Console Application will display information messages in the command prompt. Allow the process to finish.

Create and Deploy OLAP Database #

Creating OLAP Database on Server #

  1. Open an Administrator command prompt and go to the install directory, C:¥Program Files ¥OpeniT¥Analysis Server¥.
  2. Run the CreateOlap subcommand by using the syntax:
    C:¥Program Files¥OpeniT¥Analysis Server¥>OpeniT.Server.Etl.Console.exe CreateOlap
  3. The Console Application will display information messages in the command prompt. Allow the process to finish.

Deploying Olap Database Schema #

  1. Open the command prompt and go to the install directory, C:¥Program Files¥OpeniT¥Analysis Server¥.
  2. Run the DeployOlap subcommand by using the syntax:
    C:¥Program Files¥OpeniT¥Analysis Server¥>OpeniT.Server.Etl.Console.exe DeployOlap [/trace] [/clean]
    Optional parameters:

    • /trace
      This parameter triggers the command to display SQL statements for tracing.
      Example:
      C:¥Program Files¥OpeniT¥Analysis Server¥>OpeniT.Server.Etl.Console.exe DeployOlap /trace
    • /clean
      This parameter triggers the command to remove or clean missing and old objects in the OLAP database before deployment.
      C:¥Program Files¥OpeniT¥Analysis Server¥>OpeniT.Server.Etl.Console.exe DeployOlap /clean
    • Combine or use optional parameters at the same time to achieve necessary capabilities.
      C:¥Program Files¥OpeniT¥Analysis Server¥>OpeniT.Server.Etl.Console.exe DeployOlap /clean /trace

  3. The Console Application will display information messages in the command prompt. Allow the process to finish.
X