Data Hub 10.0 on-premise release notes

Our core design goals for this new UI were to:

You can now create a new resource by either:

The Settings menu has become a simple drop-down menu that displays over resources and allows you to open multiple settings pages as separate tabs. The options displayed will still depend on the assigned role of the user.

In the Profile menu, you can now:

Clicking My Profile will open a pop-up where you can edit your details.

Switching between the old and new UI is easily done by using the provided links. Switch to new UI in the menu bar of the old UI, or Switch to legacy UI in the User Profile Dropdown of the new UI.

New Resource Explorer improvements include:

The new Resource Search feature is now more prominent in the application. It has been moved from the Resource Explorer pane to the new UI's top bar to improve usability. When not selected, its background color is dark.

To search:

By adding filters to your search terms, you can focus your search on only those areas you want. Type the search filter and the resource to return your results.

Search filter	Function	Example
in:	Searches within a parent folder or model.
tag:	Searches within resource tags that are applied to resources.
type:	Searches for a type of resource.

Options such as Refresh and Save have been moved to the Tab area's right side.

Opening an existing resource always opens it in View mode.

If the current user is a Report Designer or a Full Designer, then the option to Edit the resource is available.

The ellipses display Design and Consumer options. The Consumer options and the UI of this menu resemble the UI of the Consumer view in the Legacy UI and add Summary, Security, and Properties options, previously only available in the Ribbon.

Edit or Design Analytics by clicking the Pencil icon displays familiar categories in a vertical pane.

These categories almost exactly match the ribbon menus of the Legacy UI.

Panels always display on top of resources.

The Query panel (Cube icon) shows the standard Dimension Tree as the first panel from the right. The Dimension Tree is only available from this panel. When creating new Analytics, the Connection options can now be found on this panel.

The design placeholders have been moved to a sub-panel of the Query panel. They do not show on the Analytics canvas and editing a resource no longer resize the analytics.

The New UI’s design experience is still a drag and drop and right click experience from the Dimension Tree onto the placeholders.

Right-clicking an element in a placeholder shows the usual Action and Function menu.

You can also type text in the placeholder to search and add a new Function.

Editing or Creating a Function, such as a Custom Formula, collapses the Query sub-panel to display the Function's placeholders.

In addition to displaying the usual Functions, right-clicking a blank area in a placeholder also shows Calculator options. The Boolean options of the old Calculator pop-up have been moved here.

Operators are available by typing on your keyboard, press enter, or click the item to select.

Improved error notifications.

Type a number, then press Enter or select the number from the drop-down list. Single-click to edit numbers.

Remove items by selecting and pressing Delete, using Backspace, or right-clicking and selecting Remove.

Home

Data

Table

Chart

Design

Axis

Although many changes to the Data Model UI are planned, the Data Model view has not received many UI changes in this current version. You will, however, notice the introduction of the same Vertical Design pane on the right and a new Connection option.

The Connection panel summarizes everything required to connect to the Data Model’s Warehouse. It is a Usability and Integration feature that avoids navigating multiple Data Hub areas to source such connection information (e.g., Model Server, Data Model, Role). It is handy when configuring connections to a Model’s warehouse from a ZAP Power BI App.

Buttons let you Copy information or Edit the resource that provides such information.

This panel/option is also available in Simple Model View.

The main Portal URL now redirects to the new UI on Desktop devices, not the Consumer view. The Consumer view is still used by default on mobile devices. The Consumer view can still be accessed from the Share menu or by adding /View to the URL.

Chart resources have been renamed:

Buttons and a Boolean function menu have replaced the Calculator pop-up in Formula placeholders. The Drill-through target placeholder has been moved to the Data panel.

The waterfall, also known as a bridge or cascade chart, portrays how an initial value is affected by a series of intermediate positive or negative values. Usually, the initial and the final values (endpoints) are represented by whole columns. In contrast, the intermediate values are shown as floating columns that begin based on the value of the previous column. The columns can be color-coded to distinguish between positive and negative values.

Create a waterfall chart

Some time ago we introduced the Viewer profile so users who do not need to perform any other functions can simply view reports. With v10, we have now merged the Viewer and Consumer profiles providing improved security, easier less confusion.

We have made some changes to the Time functions that will simplify their use.

We:

To run a query in the preview pane, you click the Execute button, however, if you wish to cancel the query, it was not previously obvious how to perform this.

In this update, once you have clicked Execute, the button text will now change to Cancel so it is clear that this cancels the query.

For users who have multiple data sources, clicking the Test Connection button sometimes encountered an offline data source which prevented the data modeling process from completing.

This issue has been corrected by allowing the data model process to ignore any offline data sources and complete the process.

We have added support for OData filtering (timestamp for incremental loading and also custom date columns, for only migrating 2 years) for our Business Central cloud data source.

Users now have the ability to force sequential processing on multidimensional cubes (instead of parallel processing) by clicking Force Sequential.

We have made some improvements in the background that enable faster processing of pipelines.

In previous versions of Data hub, whenever gateway updates became available, customers were required to download the new gateway installer and rerun it on the source server. From v10 we have improved this experience by enabling the gateway to update itself. Once a new update is available, it will automatically update the gateway the next time it is used, e.g. when a model's connection is tested. In order for the new v10 gateway update to function, it requires Microsoft .Net Framework 4.8. This does require a once off manual installation on the gateway host.

This Knowledge Base article provides a notable subset of the defect resolutions.

For instructions on upgrading Data Hub, see: Upgrading an Existing Data Hub Installation.