Skip to main content

November 2023

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

K76_AddRefRelationship.jpg
K76_RefRelationshipFields.jpg

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.

K76_BackgroundTaskRunningInfo2.jpg

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)}}

k76REST_pagination_update.jpg

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)

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

    K76_D365ApplicationServiceUser.jpg

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.

Date of publication 14 October 2023