Skip to content

Business Reporting & Analysis Prerequisites

This page provides information about necessary prerequisites for different areas within Business Reporting & Analysis.

Business Reporter

Software Versions Editions Comments
Windows Client OS According to the Windows Based Clients section of the Supported Platforms for IFS Cloud.
Microsoft Office Excel According to the Microsoft Office Products section of the Supported Platforms for IFS Cloud. Professional Plus If a customized installation is performed, please make sure that the .NET Programmability Support feature is selected.
Adobe Reader According to the Non-Microsoft Server products section of the Supported Platforms for IFS Cloud. Not mandatory

IFS Business Reporter reports can be set up to open as PDF. This applies for reports opened within IFS Enterprise Explorer, via Order Report dialog or via the report archive, either opened in the BR pre-viewer or in Excel.
To make this work it will be necessary to install Adobe Acrobat Reader on the machine where IFS Business Reporter will run.
.NET Framework According to the Windows Based Clients section of the Supported Platforms for IFS Cloud.  
Microsoft Visual Studio 2010 Tools for Office Fourth Edition Runtime VSTOR 2010 This prerequisit should be downloaded from here:
https://www.microsoft.com/en-us/download/details.aspx?id=48217
Windows Installer Windows Installer 4.5   Normally this software is bundled with Windows 10 installations. If not it could be downloaded from here:
https://www.microsoft.com/en-us/download/details.aspx?id=8483
Microsoft Visual C++ 2010 runtime Microsoft Visual C++ 2010 runtime is a prerequisite for ClickOnce installations of IFS Business Reporter. Normally this is included in Windows 10 installation. Install this prerequisite only if it is not installed through Windows installation. It could be be downloaded from via below links.
For 32 bit versions of Microsoft Excel - Microsoft Visual C++ 2010 Redistributable Package (x86)
For 64 bit versions of Microsoft Excel - Microsoft Visual C++ 2010 Redistributable Package (x64)

Business Reporter Execution Server

Software Versions Editions Comments Limitations
Windows Server OS According to the IFS Middleware Server section of the Supported Platforms for IFS Cloud.
Business Reporter IFS Business Reporter Execution Server (BRES) does not required IFS Business Reporter to be installed on the BRES host.
   
Microsoft Office Language Packs The machine that hosts IFS Business Reporter Execution Server must have a MS Office version installed that matches the locale, CultureInfo, of the end user's regional settings. Else install the MS Office MUI (Multilingual User Interface) according to the end users' locale.

Note: This prerequisit is needed when running BRES in VSTO mode only.
Microsoft Office Excel According to the Microsoft Office Products section of the Supported Platforms for IFS Cloud.
MS Excel is needed if IFS Business Reporter Execution Server is running in VSTO mode.
Professional Plus If a customized installation is performed, please make sure that the .NET Programmability Support feature is selected.

Note: This prerequisit is needed when running BRES in VSTO mode only.
Problems have been found related to Office 365. It is not recommended to install and use the 365 Office version on a computer hosting IFS Business Reporter Execution Server. Since IFS Business Reporter Reporter Server is regarded as a server application, the recommendation is to use an on-premises version of Office. Please note that for this scenario there is small possibility that report designers might get access to Excel functionality that is not yet available in the on-premises version which can lead to that that the Execution Server cannot render the reports correctly.

It is not possible to install IFS Business Reporter for many users if Microsoft Office 365 is used since it is based on single prescriptions.
Adobe Reader According to the Non-Microsoft Server products section of the Supported Platforms for IFS Cloud. Not mandatory.
Not needed if IFS Business Reporter Execution Server is running in OOXML mode.

IFS Business Reporter reports can be set up to open as PDF. This applies for reports opened within IFS Aurena via Order Report dialog or via the report archive.
To make this work it will be necessary to install Adobe Acrobat Reader on the machine where IFS Business Reporter Execution Server will run.
.NET Framework According to the Windows Based Clients ; section of the Supported Platforms for IFS Applications 10.  
Microsoft Visual Studio 2010 Tools for Office Fourth Edition Runtime (VSTOR 2010) VSTOR 2010 This prerequisit should be downloaded from here:
https://www.microsoft.com/en-us/download/details.aspx?id=48217

Note: This prerequisit is needed only when running BRES in VSTO mode.
 

Analysis Models

Software Versions Editions Comments Limitations
Windows Server OS According to the IFS Middleware Server section of the Supported Platforms for IFS Cloud.
SQL Server According to the Microsoft Server Products section of the Supported Platforms for IFS Cloud. The following SQL Server features are required:
Instance Features
 - Database Engine Services
 - Analysis Services
Shared Features
 - Client Tools Connectivity
 - Integration Services
 - Client Tools SDK
 - SQL Client Connectivity SDK
 - SQL Server Data Tools
SQL Server Management Studio (SSMS) According to the Microsoft Server Products section of the Supported Platforms for IFS Cloud. Prerequisites for the Environment Setup step.
- Database (the IFS Datawarehouse)
- Catalog folder name in SSIS Integration Services
- User for SQL Server access from Aurena (SQL Server authentication)
- User for SSAS access from Aurena (Windows Integrated Authentication)
Oracle Data Access Components According to the Non-Microsoft Server products section of the Supported Platforms for IFS Cloud. The following product components of the Oracle Data Access Components (ODAC) are required:
- Oracle Advanced Security
- Oracle Provider for OLE DB
- Oracle Data Provider for.NET
ODAC 12.2.0.1 has known performance issues (memory consumption in SSIS) and is NOT recommended.
SQL Server Data Tools (optional) SQL Server Data Tools 2017 or 2019 Freeware from Microsoft.
Primary design tool for SQL Server Tabular Models.
 
Tabular Editor
(optional)
Tabular Editor 2.11.7 or later Open Source freeware.
Useful design tool for SQL Server Tabular Models.