Postgres/TimescaleDB leaves us without a reporting engine. SSRS is licensed part of MSSQL.

MikaelKrantz · ‎2023-01-31

Issue

Moving from Webreports going to Postgres/TimescaleDB instead, leaves us without a reporting engine. SSRS can supposedly utilise a PostgreSQL database, but SSRS is a licensed part of MSSQL.

Product Line

EcoStruxure Building Operation

Environment

Building Operation Timescale Database

Cause

From EcoStruxure Building Operation version 4.0 (2022) the Building Operation Report Server is no longer supported.

Instead, we support PostgreSQL/TimescaleDB, using Dashboards and Excel from within EBO, to make reports, using Notification reports to start Excel and reports.

Resolution

EBO 3.2 introduced Enhanced Reporting, based on the current feature Notifications in combination with Notification Report Template, which also supports report data such as Alarms, Groups, Multi Log
list, Relative events and Users. The Notification result can also be presented in XLSX format and
converted to PDF with signing capabilities. If External Log Storage is configured and connected
(PostgreSQL/TimescaleDB), then historical report data can be fetched from there.

EBO 2023 introduced External Log Storage support for Microsoft SQL Server in addition to PostgreSQL/TimescaleDB

Information and examples of Enhanced Reporting and Dashboards can be found in EBO Webhelp, My LearningLink and the Automation Experts Community.

NOTIFICATION REPORTS :

EBO Webhelp: Notification Reports

Community: Reporting in EcoStruxure Building Operation 3.2

Community: Reports showcase - share your reports!

Community: Get more data out of the system with Notifications!

EcoXpert Extranet Video: Community Video : Fusion Fridays - Session 20

Community: Change Control and Enhanced Reporting Lab Guides

Community: Example Report Templates

Community: Forced Values Report Example

My LearningLink: EcoStruxure Building: Enhanced Reporting and Dashboards 3.2