Skip to main content

November 2023

· 3 min read

Release number: K76

Modeling enhancements​

Reference relationships​

An exciting new relationship addition for modeling in DATA HUB: Reference relationships . It is the ability to add a relationship path from a measure group > dimension > dimension. More details at Defining reference relationships.

Add a reference relationship

Configure a reference relationship

Additional Information for background tasks​

The duration a task has been running or queued for is now visible in the status column. When hovering on the status, the task start time is visible.

Background tasks

In addition, when a task is cancelled it will now show when it was cancelled and how long the task was active for, e.g.

  • Cancelled while running will show Ran for ...
  • Cancelled while queued will show Queued for ...
  • Cancelled while deferred will show Deferred for...

Connector enhancements​

SAP Business One - new HANA connection​

A new HANA connection has been added that supports a highly flexible SQL Query and is much easier to configure.

Details and instruction steps can be found in SAP Business One configuration settings

REST connector - variable update​

When working with REST pagination variables {{SkipCount}} and {{PageCount}} some APIs require an explicit value specified for the first page.

An optional argument has been added to specify the first page.

{{PageCount(100, 1)}} and {{SkipCount(20,2)}}

REST pagination variables

D365 Sales - New Authentication method​

A new authentication method has been added.

D365 Sales now supports two authentication methods:

  • User Authentication - requiring a username and password (Existing)

    User credentials

  • Application User - a service account only used for direct API access. (New). Details about this method and how to configure it is available.

    Application service credentials

Analytics enhancements​

Drill-through - enhanced time context slicer behavior.​

When a drill-through target has a time context slicer, drilling through will replace the time context slicer selection instead of replacing it with the filter or slicer from the source report.

Performance enhancements​

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