2023.05 » New Features and Enhancements

Merge Widgets / Sub-Views vertically with shared column dimension NEW Feature

Version 2023.05 introduces new feature that closely resembles connected widgets and row master options already available in the app. However, it takes things to a whole new level by providing users with the ability to merge both views and grid widgets based on the common column dimension.

 

The advanced options panel in the cube settings includes now new Master Widget (Columns) available for grid widgets or Master Column option available for views, which allows users to select a master view for merging data.

 

Open

 

 

 

 

Selected dimensions on rows have labels visible in the row header for both dimensions to provide users with a quick way to identify the dimensions they are working with, making it easier to analyze data.

 

Open

 

Users can still use basic grid/views functionalities like drill, inserting new rows and columns, or utilize subset editor shortcuts available in the table context menu. This feature also supports stacked dimensions, providing users with even more flexibility in creating reports.

Virtual / Helper dimension on filter bar NEW Feature

This version also brings addition of Virtual / Helper dimensions. One of the main benefits of this feature is that users can add the same dimension to the global filter section, provided that the Settings Key defining the dimension is different allowing to apply advanced data filtering options.

Key defining the dimension will be displayed in the advanced options panel, making it easy for users to copy and use in UX placeholder context.

We're also introducing the ability to create custom dimensions with user specified list of elements. With this enhancement, users can enjoy greater flexibility in defining the data they want to work with.

Status bar for tables (Sum/ Average/ Count) new FEature

The latest version 2023.05 comes with an additional feature » Status bar

It can provide valuable insights for data analysis and help gather relevant information. This feature offers a summary of selected cells in a grid or view, visible in the page title section. It includes average, minimum, maximum, count, and sum of the selected cells, with 0 values excluded from from the calculations for greater accuracy.

To remove the Status Bar click on any cell in the table.

Export to Excel as a slice with DBRW’s and Subnm’s NEW Feature

In the version 2023.05 users also have an option to Export to Excel as a slice with DBRW’s and Subnm’s and use excel file for interactive data analysis. New advanced option in toolbar section has been added so that the users can enable export as DBRW slice under the Export button for specific reports.

Sandbox Data Entry new FEature

The default value for the sandbox is Base representing the original values. However, users can easily create new sandboxes by inputting a custom name and clicking on the plus icon. Once it’s created, those additional options will be available:

When changes are discarded, all updates made under a specific sandbox are removed, so it’s recommended to use cube names when creating sandboxes to make tracking and management easier.

After selecting a sandbox, any modifications made are highlighted in blue for easy identification. Users can compare changes by selecting different sandboxes from the dropdown list, for quick analysis.

Text Auto complete for settings service values (using Ctrl + Space) new FEature

Users can now use the auto-complete feature to quickly reference any setting service value used in the current report. This feature works with user-defined dimension key values, aliases, or attributes, and is available in the Titles, Advanced Options Editor (CODE tab), and Cube Settings.

To activate it, simply press the shortcut keys Ctrl+Space within the textbox.

Row format based on class defined in a table column new FEature

With the latest update, new advanced option called "classColumn" has been added under the Row Format section in the advanced options GUI. This allows users to define specific formatting for rows or combinations of rows based on the class defined in the table column.

Wizard edit mode improvements IMPROVEMENTS

This latest release includes significant improvements to the wizard edit mode. Users can now enjoy a faster and smoother editing experience, as the entire wizard will no longer refresh when adding new widgets, steps subSteps, saving or discarding changes.

Cube Settings improvements IMPROVEMENTS

Version 2023.05 brings also improvements to cube settings:

Charts

» new advanced options IMPROVEMENTS

This version introduces a major update to our chart options, providing users with more control over the appearance and functionality of their charts. Users can access a range of new sections and options in the advanced options panel, which enables easy and fast customization.

The new sections include: Chart, Legend, Tooltip, Plot Options, updated Series, x-axis, y-axis, and they offer variety of options, such as changing chart types, modifying background colors, and enabling zoom functionality. Users can also manage the visibility, position, and layout of their legend and customize the formatting of the tooltips.

One of the benefits is also updated series section with new Marker subsection, which allows users to enable or disable markers or format them if needed. The Type section has also been improved, now offering more formatting options.

In addition to the updates mentioned above, enhancements were also done to x-axis and y-axis sections, which now include new options for formatting, enabling users to customize axis types to their preference and style and position labels in the chart axis. The Crosshair section also enables users to adjust how the crosshair lines appear in their chart, making it easier to focus on specific data points.

All of these new options are available in the advanced options panel, to view the full list please visit article: 2023.05 » New Control Parameters

» new chart types new FEature

This release not only brings significant improvements to chart advanced options, but also introduces two new chart types: Radial and Bullet.

Subset Editor Improvements IMPROVEMENTS

In this release, we have added also new features to the subset editor:

TI Process IMPROVEMENTS

This release includes also improvements to TI process:

Rollup Class IMPROVEMENTS

Users can define and customize a new class that will be automatically applied to all new consolidated elements and their corresponding cells. By default, all rollup elements have a rollupRowClassclass applied. This makes it easy for users to create a custom format by simply creating a new class.

For example:

With this new class, users can easily customize the appearance of rollup rows by changing the background color.