Upcoming Webinar: Register now >>

OpenLM_Icons_Reporting Hub

OpenLM Reporting Hub

The following is a log of all enhancements and bug fixes introduced with OpenLM Reporting Hub releases. For general information about the OpenLM Reporting Hub, please take a look at our Documentation page.

Also, consult the system requirements document before installing.

 

v24.7
July 22, 2024
Added

44715: clientlicenseversion column to Power BI reports for filtering data by client license version

Fixed

47452: Multiple Family IDs within a single session

Updated

52227: SpringFramework to 5.3.26 version

Added

52474: Added the ability to filter data by server.โ€จ

Added

46223: Added the ability to send emails using SSL

Fixed

51790: In the process of updating data regularly (incremental ETL), there are repeated entries (duplicates) in the column named concusage within the table called featureusagemeasurehourly_splitโ€จ

v23.2
February 13, 2023
Added

42267: Added default settings configurations for .kettle

Updated

38789: Java version upgrade to OpenJDK11U-jrex64windowshotspot11.0.17_8

Updated

38789 : JDBC Drivers update (mariadb-java-client-2.7.5 mssql-jdbc-9.4.1 postgresql-42.2.9)

Updated

38789: Pentaho 9.3 upgrade

Fixed

42186: Target MSSQL transfer - "Cannot drop the view 'sys.databasefirewallrules', because it does not exist or no permissions"

Fixed

42234: Uppercase alias errors on a case-sensitive MySQL databases

Fixed

38100: PowerBI reports Hourly License Quantity calculation issue

Fixed

42109: Target database creation issues on MySQL

Fixed

41646: MSSQL Destination drop constraint error

Fixed

38560: License with no usage now is not displayed

Fixed

41718: Anonymization failure

Added

37738: The Used Dimension now has a "country" field

v21.11
November 17, 2021
Fixed

29623: Reporting hub: Cloud - ETL fails on the denials step when generating the month

Fixed

31235: Reporting Hub: a single feature has several rows in the DB

Fixed

31503: Reporting Hub: ETL is not collecting features with a version

Fixed

32515: Reporting Hub: ETL failure in customer's DB

Fixed

33621: Reporting Hub: ETL fails on indexes

Fixed

33745: Reporting Hub: Kettle path fix

Fixed

33815: Reporting Hub: ETL throws Invalid column name - INCREMENTAL=false recreates Postgres DB schema BUT not MS SQL schema

Fixed

33979: Reporting Hub not starting

Fixed

34034: Reporting hub is not creating Postgres database

Fixed

34036: Reporting Hub ETL fails on data extraction

Fixed

33933: Reporting Hub - ETL Status table is not logging failed ETL status

Fixed

34349: Reporting Hub: Latest ETL fails on UTF issues

Fixed

34497: Reporting hub ETL - maxusagedate variable is not found

Fixed

35126: Reporting Hub SaaS cloud ETL - transfer from postgres to mysql fails

Added

30141: Reporting Hub: Conversion mechanism for kettle files

Improved

30344: Reporting Hub: Kettle file - edit variable names to be more descriptive

Added

30559: Reporting Hub: Add table for host availability

Improved

31241: Reporting Hub: Data anonymization

Added

31242:Reporting Hub: Add status table

Improved

33490: Reporting Hub: Rename DB Connection variables to match Data Migration Tool

Improved

33666: Reporting Hub: MySQL denials transfer performance optimization

Improved

33682: Reporting Hub: Add Destination DB: Create functionality for the external transfer

Compatibility

33768: Reporting Hub: Align to the Versioning template

Deprecated

33878: Reporting HUB : Firebird deprecation

Added

33991: Reporting HUB : Add license expiration date to the reporting License ETL

Improved

34283: Reporting Hub ETL - Sequential runs per vendor

Added

35040: Reporting Hub ETL - remove denials stream that uses "LICENSE_ID"

v5.4
January 12, 2021
Added

29434: Reporting Hub ETL - Starting date variables

Added

29433: Reporting Hub ETL - Normalize value names

Fixed

29172L: Reporting Hub ETL - transfer to MSSQL happens twice

Fixed

29097: Reporting hub ETL - ETL_VERSION update fails

Fixed

29067: Reporting Hub - Remove requirement for temp folder

Fixed

27886: Reporting Hub - Denials sid_hourly not created correctly

Fixed

27859: Reporting Hub - Quantity table get deleted server data

Fixed

27207: Reporting Hub - Duplicates in workstation primary key

Fixed

26976: Reporting Hub - Transfering to MySQL fails

Fixed

26975: Reporting Hub - License Quantities are not showing up

Fixed

26744: Reporting Hub build - Live calculation folder is missing

Fixed

26527: Reporting hub - missing a column "License Manager type"

Fixed

26416: Reporting Hub - Reserverd licenses flag is not being considered

Fixed

26353: Reporting Hub - Denials query performance.

v5.0
July 19, 2020
Added

26101: Reporting Hub - Packages not working correctly

Fixed

25263: Reporting Hub - No success or error state in job

Fixed

25253: Reporting Hub - License quatity presented

Fixed

25227: Reporting Hub - Deleting temp tables fails

Fixed

24555: Reporting Hub - Additinal key value in external destination should be 1000 chars long

Added

24511: Date value is duplicated when transfering from Postgres to MSSQL

Fixed

22263: Reporting Hub - Automatically edit postgresql.conf and pg_hba files

Added

22262: Reporting hub ETL - Create DB automatically

Added

22190: Support case sensitive databases in Reporting Hub

Added

22185: Test Postgres 12 with Reporting Hub

Added

22017: Reporting Hub ETL - Daily run does not remove tmp tables

v4.5
September 19, 2019
Fixed

21641: Reporting Hub ETL runs slowly on MySQL for Phillips

Fixed

21639: Reporting hub ETL grabed duplicated value

Improved

21574: Redesign Reporting Hub to fit very large datasets

Added

19612: Reporting Hub - Increase license server name character count ( Varchar(100) --> Varchar(400) )

Added

16635: Reporting Hub - Implement the "Live" functionality in the current reports.

Fixed

16011: Reporting Hub - Hourly Concurrent Usage table showing wrong value

Added

16010: Reporting Hub - "Live" concurrent usage is slow on large databases

Added

16009: Reporting Hub - Add Candidate Expiration Date to License_Dimension table

v4.2
December 16, 2018
Added

14760: Reporting Hub - License Expiry in license file name

Added

14749: Reporting Hub - ETL workstation query taking a long time

Fixed

13391: Reporting Hub - Foreign keys fail when hostname is blank

Added

13176: Reporting Hub: "Live" concurrent queries

v4.0
October 16, 2018
Added

13175: Reporting Hub add and fix columns

Fixed

13174: Features with "-" cause issues with ETL

Added

13171: Reporting Hub - Faster Power BI, Trend line and sum values

Fixed

13170: Aggregated and raw tables give different results

Added

9204: Hourly aggregation in Reporting hub

Added

9199: Add nested groupping to Reporting Hub data structure

v3.4
November 12, 2017
Added

6698: Add "Projects" field to the Reporting Hub

Added

6202: Test PostgreSQL 10 with Reporting Hub

Skip to content