Skip to main content

2024.4

· 2 min read

The date dimension has been extended back to the year 2000, and analytics now support copying and pasting query parts through right-click menus and drag-and-drop functionality, while database scripts are being phased out in favor of pipeline steps and calculated columns.

Modeling enhancements

Date dimension expanded to year 2000

The start year of the date dimension has been extended to 2000.

Date dimension start date

Analytics enhancements

Copy-Paste query parts

Occasionally, you may need to perform similar calculations or use the same query components in various locations. The capability to duplicate these elements by copying or dragging them to the desired spots, followed by required modifications, significantly enhances functionality and user convenience

Right-clicking and selecting Copy, then paste by right-clicking on a placeholder and selecting the Paste option

Copy query part

Ctrl-drag to copy a query part instead of referencing or moving it.

Ctrl-drag query part

Right-click drag option to copy query part instead of referencing it.

Deprecated functionality

Database scripts are being phased out

Database scripts are being phased out. Using scripts can complicate data flow unnecessarily and often introduce data or performance problems.

Most use cases for scripts are better served by pipeline steps and calculated columns, e.g. if a script was copying values from one table to another, a from-pipeline pipeline may be the preferred solution. If the script was changing data in a pipeline table, a calculated column is the solution

Existing scripts will continue to work, but best practice would be to migrate functionality into pipelines for the future.

Download On-premise version

Download Data Hub.

Performance Enhancements

Every release contains performance enhancements and bug fixes to improve Data Hub.