Release Overview

Release Date

June 26, 2023

Release Type

Hot Fix

Summary of Changes

The purpose of this document is to provide you with the latest update on changes made for the release of IFS Reporting 2.20.0.2 and notify you of the expected date of this release. IFS Reporting 2.20.0.2 resolves a bug that sets the default database port to 1433. The port number is now adjustable if needed.

Compatibility Matrix

Product Certification

^COMPONENT	^{OS NAME}	^{OS VERSION}	^{OS EDITION}	^{OS ARCHITECTURE}	^{SUPPORT STATUS}	^{CERTIFICATION}	^TESTED	^NOTES

^COMPONENT	^{OS NAME}	^{OS VERSION}	^{OS EDITION}	^{OS ARCHITECTURE}	^{SUPPORT STATUS}	^{CERTIFICATION}	^TESTED	^NOTES
Application Server	Windows	Server 2022	Standard	X86_64	Supported	Supported	Y	Apache Tomcat 9, Windows SQL Server 2019, Jaspersoft v8.1.1 ETL Server - Windows Server 2022 (64-bit)

Interoperability Certification

TARGET PRODUCT	TARGET VERSION	CERTIFICATION STATUS

TARGET PRODUCT	TARGET VERSION	CERTIFICATION STATUS
IFS AFE	22.2.0.0	Supported
IFS BOLO	13.9.23.0	Certified
IFS Enterprise Upstream	13.06.01	Supported
IFS Excalibur	9.1.13	Certified
IFS iLandMan	2.12.10	Certified
IFS Land	5.24.0.0	Certified
IFS Merrick	4.10.01	Certified
IFS Workflow	1.6.1	Supported

Recommended System Requirements

Server Hardware

This section identifies the recommended hardware requirements for each server.

COMPONENT	MINIMUM	RECOMMENDED

COMPONENT	MINIMUM	RECOMMENDED
CPU	4 Core 2.5 GHz+	8 Core 2.5 GHz+
RAM	16 GB	32+ GB
Disk	250 GB	500 GB

As of release 2.10, the Budget and Forecast module in IFS Reporting will require additional disk space on your SQL server to accommodate the new dataset.

Note: The projected data volume for the Budget and Forecast module will approximate the volume of the Cost Center Summary table (FIN.FactCostCenterActivity).

As of release 2.10, the Budget and Forecast module in IFS Reporting will require additional disk space on your SQL server to accommodate the new dataset.

Note: The projected data volume for the Budget and Forecast module will approximate the volume of the Cost Center Summary table (FIN.FactCostCenterActivity).

As of release 2.10, the enhancement of the Cost Center Summary ETL in IFS Reporting will require additional disk space on your SQL server to accommodate the new dataset for IFS Excalibur customers. No changes are expected for IFS BOLO customers.

Note: The projected data volume for the Cost Center Summary ETL will approximate the volume of the Cost Center Summary table (FIN.FactCostCenterActivity).

As of release 2.13, the enhancement of the BOLO Data Schema in IFS Reporting will require additional disk space on your SQL server to accommodate any added extractions for IFS BOLO customers. By default, this supplementary extraction process is not enabled, but specific tables can be activated as needed. No changes are expected for IFS Excalibur customers.

Note: The projected data volume for the full BOLO SQL data extract will be approximately double that of the BOLO Unidata table size.

Minimum System Requirements - Software

Server Machine:

COMPONENT	REQUIREMENT

COMPONENT	REQUIREMENT
Web Server	Tomcat 9
Database	SQL Server 2019
Programming Platform	OpenJDK 11
Web Browser	Google Chrome (Recommended) Firefox Internet Explorer (Should not be in Compatibility Mode) Microsoft Edge

Additional Reference Material

User Guides

You may find the following documents useful:

IFS Reporting Basic User Training Guide

This document provides an overview of basic IFS Reporting usage, including how to access IFS Reporting content, create and format Ad Hoc Views and Reports, and schedule Reports and Dashboards.

IFS Reporting Intermediate User Training Guide

This document provides in-depth instruction on advanced functionality for Ad Hoc Views, charts and dashboards, including calculated fields and measures, advanced chart formatting, and drill-down and drill-across hyperlinking in dashboards.

IFS Reporting Advanced User Training Guide

This document provides in-depth instruction on advanced functionality in IFS Reporting, including creating standard and virtual data sources, working with domains, calculated fields, filters, and derived tables, and determining resources that depend on a domain.

IFS Reporting Installation Guide

Installing and configuring IFS Reporting for a first-time user. See the P2 Store.

IFS Reporting Troubleshooting

Please see the Troubleshooting page.

Release Contents

Enhancements

There were no Enhancements included in IFS Reporting 2.20.0.2.

Issues Resolved

MODULE	SUMMARY	NOTES

MODULE

SUMMARY

NOTES

Engine Installer

Port Setup Defaults to 1433

Issue: Setting in Engine Installer defaults to port 1433 and does not allow adjustment.

Resolution: Engine Installer now allows users to change port if desired.

API Modifications

There were no API Modifications included in IFS Reporting 2.20.0.2.

Security Modifications

There were no Security Modifications included in IFS Reporting 2.20.0.2.

Seed Data Modifications

There were no Seed Data Modifications included in IFS Reporting 2.20.0.2.

Datamodel Modifications

There were no Datamodel Modifications included in IFS Reporting 2.20.0.2.

Metadata Modifications

There were no Metadata Modifications included in IFS Reporting 2.20.0.2.

Configuration Modifications

There were no Configuration Modifications included in IFS Reporting 2.20.0.2.

Modifications Affecting Upgrades

Due to major changes in the IFS Reporting Engine, a uninstall of the current reporting engine is required prior to installing version 2.20.0.2.

Known Issues

SUPPORT ID	MODULE	SUMMARY	NOTES

SUPPORT ID