New Features and Enhancements

1. Connected Widgets

One of the key features in version 2021.11 is the ability to connect widgets. The functionality works on similar principles as creating reports with multiple sub-views. Users can combine widgets from the same or different cubes (also with stacked dimensions).

After connecting the widgets, the cube settings from the master widget will apply to other tables e.g. row dimension attribute, subset or zero suppression settings. Column dimension from the master widget will be the first one to be displayed in the new connected grid.

Widgets can be enhanced with advanced formatting or additional rows and columns using the formulas. Chart type is also supported.

Note:

All of the base grid widget functionalities are also available for connected widgets. 

2. adHoc columns edit

Creating views or widgets that use asymmetric elements on stacked column dimensions has now become less complicated. After enabling advanced adHoc columns option, users will have access to a new set of toolbar (or widget header) buttons to facilitate column editing without the need to manually change MDX query. This functionality is available not only to power users but also to end users. Changes can be made outside of the Edit Mode, but will be reset upon a full page refresh.

Available options:

  • Add Column (+ icon): A new column will appear in the table with the default dimensions configured. (Configuration must be done in the json file using new "columnDefaultElements" option. The report creator can optionally define dimension, hierarchy, subset and default element which will be automatically applied to an inserted column)  
  • Duplicate columns: After selecting a column from the grid the button becomes active. After clicking it, duplicated column will appear in the table.    
  • Remove Column (trash can icon): Remove selected column from the table. 
  • Pencil icon visible in the column headers allows users further customization of the stacked dimension without the need of changing MDX query.
  • Save Columns: The changes will disappear after the full reload of the page, unless they were made in Edit Mode and the user selected Save Columns option. 

The user must have WRITE access to the view / dashboard granted in order for the changes to be applied (after clicking Save Columns button). 

3. Highcharts improvements

3.1. Null Values

Improvement added in the UX 2021.11 release allows users to change small values to null in charts with the use of new advanced options. Max value threshold can be manually adjusted. 

3.2. Waterfall Single Element

  • Single First Point : newly added option, which complements the existing color configuration (Single End Point), allowing user to change the color of the first column in the chart.  
  •  Y-axis scaling : in the 2021.11 release this option is also available for the Waterfall Single Element chart type to set the minimum value of the Y-axis which can make the displayed data more readable by giving more vertical height to the variance bars. 
4. Dynamic hierarchy using placeholder

UX version 2021.11 allows users to dynamically define a hierarchy using a placeholder. This configuration will work for global filters as well as for dimensions selected in rows or columns. 

Cube Settings configuration: 

After clicking Select button the Hierarchy dropdown list will be changed to text box to enable placeholder input. 

5. Nested UX Placeholders

This version also allows the use of nested UX placeholders which gives users freedom to create even more flexible dynamic selections. 

Below example shows that by nesting two UX placeholder statements within each other users can not only define dynamic element selection based on filters, but also dimension hierarchy.  

{[Product].[$<<UX_Demo.}Hierarchies_Product.}Hierarchies_Product>>].[$<<UX_Demo.Product.$<<UX_Demo.}Hierarchies_Product.}Hierarchies_Product>>>>]}
Click to copy
6. Cancel long running MDX requests

In case of long loading reports new Cancel Thread option is available. When the loading process takes longer than 10 sec, a task notification informing that a hanging thread has been detected will appear. 

The user can choose to cancel the thread and an error message will be displayed. The more time that is taken before the cancel option is clicked, more likely it is that the request will not be canceled and the view will try to load. 

Note: there are cases when multiple notification can appear at once. This means that multiple hanging threads have been detected, each thread will have a unique ID.  

7. Export All Tables in the Dashboard

Version 2021.11 introduces improved Export All Tables in Dashboard option. After selecting it, all widgets will be temporarily changed into grids and exported to single excel file. Each widget will be saved in a separate tab. 

8. New method for column & row formatting

The latest version of UX includes also a new way to format columns and rows based on their index position in the table. This is to handle use cases where the selection (and names) of rows or columns may be dynamic but certain positions in the table (e.g. the top row, left most column) should always have the same format applied

9. Subset Editor improvements
  • Confirm the selection of dimension elements by clicking Apply without having to save it first with the Keep button
  • Apply button will not become active for fixed dimension until the default value is edited, all other mdx modifications are not seen as a change. 
10. Hide & Reveal options for rows and columns (supported also in charts)

In this release there are new context menu options available for views and grids:

  • Hide row - hide selected row 
  • Reveal hidden rows / columns - reveal all hidden rows / columns 

This option is also supported in charts after selecting Show Source Data:

11. New cube settings option for global filters: Disable Selection

Another improvement available in this release is a new option added for global filters in the cube settings that allows users to disable the filter selection of a given dimension. Contrary to dashboard fixed values it can use an advanced mdx query.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.