| Table of Contents | ||||
|---|---|---|---|---|
|
| Aura divider | ||||
|---|---|---|---|---|
|
Merge Widgets / Sub-Views vertically with shared column dimension
| Status | ||||
|---|---|---|---|---|
|
Version 2023.05 Beta introduces new feature that closely resembles connected widgets and row master option 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.
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.
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.
| Aura divider | ||||
|---|---|---|---|---|
|
Virtual / Helper dimension on filter bar
| Status | ||||
|---|---|---|---|---|
|
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.
| Info |
|---|
NOTE: Users can also use now new shortcut ctrl + space to access the list of available settings service placeholders » go toText Auto complete for settings service values (using Ctrl + Space) section in this article to get more information. |
We're also introducing the ability to create custom dimensions and specify the with user specified list of elements. With this enhancement, users can enjoy greater flexibility in defining the data they want to work with.
| Aura divider | ||||
|---|---|---|---|---|
|
Status bar for tables (Sum/ Average/ Count)
| Status | ||||
|---|---|---|---|---|
|
The latest version 2023.05 Beta 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.
Additionally, new advanced option under card config has been implemented, allowing users to enable the Status bar (Cell Summary) to be displayed in the widget header, in cases where title space is not available » e.g. in popups or dashboards with hidden titles.
| Aura divider | ||||
|---|---|---|---|---|
|
Export to Excel as a slice with DBRW’s and Subnm’s
| Status | ||||
|---|---|---|---|---|
|
In the version 2023.05 Beta 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.
Users can now export cell references displayed in a report, rather than static values. Those references allow to dynamically pull data from the tm1 server. To use this feature, an Excel add-in (such as Slice) must be installed and configured to connect to the server. In addition, the exported Excel file will include a filters section, adding flexibility to the data analysis process.
| Aura divider | ||||
|---|---|---|---|---|
|
Sandbox Data Entry
| Status | ||||
|---|---|---|---|---|
|
This version presents users with a new feature called Sandbox, which provides increased control over data changes in the reports, and is now available as an advanced option in the toolbar section. When enabled, users gain access to a new set of buttons in the page toolbar.
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:
publish the changes
publish data and update the base values
discard the changes
discard changes made within the sandbox to revert to the base values
delete the sandbox
remove the sandbox from the dropdown list of available sandboxes.
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.
| Aura divider | ||||
|---|---|---|---|---|
|
Wizard edit mode improvements
| Status | ||||
|---|---|---|---|---|
|
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.
| Aura divider | ||||
|---|---|---|---|---|
|
Cube Settings improvements
| Status | ||||
|---|---|---|---|---|
|
Version 2023.05 Beta brings also improvements to cube settings:
add new widgets / SubViews from the cube settings dialog level with the new "+" button located in the tab section.
delete widgets / SubViews with a single click using the intuitive trash can icon visible next to their name.
| Aura divider | ||||
|---|---|---|---|---|
|
Charts advanced options
| Status | ||||
|---|---|---|---|---|
|
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 their tooltipthe tooltips.
One of the key benefits of the is also updated series section is the 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 Beta » New Control Parameters
| Aura divider | ||||
|---|---|---|---|---|
|
Text Auto complete for settings service values (using Ctrl + Space)
| Status | ||||
|---|---|---|---|---|
|
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.
| Aura divider | ||||
|---|---|---|---|---|
|
Subset Editor Improvements
| Status | ||||
|---|---|---|---|---|
|
In this release, we have added also new features to the subset editor:
Replace Unique Name
new button to remove consolidations information from member definition
All Elements & All Members
with All E button it's now possible to display only unique members of a dimension (all elements of a dimension). All M button retains the functionality of previous All button which displayed all members of a dimension (e.g. element that is part of two consolidations is treated as two members and so displayed twice)
| Aura divider | ||||
|---|---|---|---|---|
|
TI Process
| Status | ||||
|---|---|---|---|---|
|
This release includes also improvements to TI process:
enable the HTML snippet menu in the widget header
with this feature, users can now make necessary changes to the snippet code without having to close the popup, which saves time and allows for greater efficiency
subnm & subnm multi parameters
users have now the option to disable drill and hierarchy in order to customize the data presentation
process default values
will be shown correctly in the GUI and using a new toggle button user can force them to be auto-populated in the TI process modal, which can reduce the likelihood of errors
| Aura divider | ||||
|---|---|---|---|---|
|
Rollup Class
| Status | ||||
|---|---|---|---|---|
|
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:
| Code Block |
|---|
.rollupRowClass {
background-color: #4bc74b !important;
} |
With this new class, users can easily customize the appearance of rollup rows by changing the background color.