Manual Deployment

This document describes how to deploy the IFS Analysis Models manually. The information in the document is for informational purpose only and it is not related to the supported installation process.

Note: Make sure to have installed the IFS Business Reporting & Analysis/External Report Integration first since it is a prerequisite to install the integration framework before installing the IFS Analysis Models

Information about technical prerequisites can be found on the Business Reporting & Analysis Prerequisites page

The instructions are based on having a AM Instance Home as a working directory for the installation.

An AM Instance Home is created by the IFS Analysis Models Installer. The installer modifies scripts with needed environment information, such as database connections and paths. Necessary files will be consolidated into the correct folders by the IFS Analysis Models Installer.

Images used in the guideline may not show exactly the same information as for your installation.

This is not an exact top to bottom manual on how to deploy the solution. Please read it through once first once and then go back to it. A step by step approach may not work.

Note: Manual installation of SQL Server Agent Jobs related to KPI Services functionality is not described in this section. Please refer to the Analysis Models Installer

Use this page to get information about how to install Analysis Models manually, i.e. when the IFS Analysis Models Installer is not used.

Contents

 

Deploy SQL Scripts

The first step is to deploy scripts to the SQL Server.

Open SSMS (SQL Server Management Studio) and connect to your database engine.

Verify that the database used in the script files are correct:

  1. Verify USE statements
  2. For the dbo.Create_Database.sql script; verify database names and paths.
  3. Verify that the lookup scripts contain the correct data.


Deploy files located in the SSMS folder, and its sub folders, through SSMS.

The SQL scripts for tables are located in the SSMS folder at the root. The SQL scripts in the sub folders are used for the creation of the database, indexes, lookup scripts and stored procedures.

Run scripts in this order:

  1. Create database scripts
  2. Table scripts in the SSMS base folder
  3. Index scripts
  4. Lookup scripts
  5. Stored procedures
  6. Views

SSAS

Learn more how to manually deploy OLAP cubes in SQL Server Analysis Services (SSAS) >>

SSIS

Learn more how to run SQL Server Integration Services packages (SSIS) >>

Run the ETL Process

Learn more how to trigger a SQL Server Agent Job >>

Excel Dashboards

Learn more how to handle Excel dashboards >>

SSRS

Learn more how to deploy Reporting Services (SSRS) reports to SQL Server >>

Create Quick Reports

This section describes how to automatically create Quick Reports referring to example content in Analysis Models.

  1. Read the readme.txt in the QuickReportScript folder in the Utilities folder in the AM Instance Home.
  2. Run the Add_QR_BI.bat file to create Quick Reports in IFS Applications which are accessible through IFS Enterprise Explorer.