| Table of Contents | ||||
|---|---|---|---|---|
|
Merged views & widgets: master column
| Status | ||||
|---|---|---|---|---|
|
This feature Version 2023.05 introduces new feature that closely resembles connected widgets and row master options option 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 ). This provides to provide users with a quick and easy 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 reportreports.
| Aura divider | ||||
|---|---|---|---|---|
|
Virtual / Helper dimension on filter bar
| Status | ||||
|---|---|---|---|---|
|
One of the main benefits of this feature is that users can add the same dimension to the global filter section, provided that the key defining the dimension is different allowing to apply advanced data filtering options.
Furthermore, the 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.
Moreover, we're also introducing the ability for users to create custom dimensions and define the list of elements. This enhancement provides even more flexibility in defining the data users want to work with.
| Aura divider | ||||
|---|---|---|---|---|
|
Status bar
| Status | ||||
|---|---|---|---|---|
|
Version 2023.05 introduces also new Status bar feature that will provide valuable insights and streamline data analysis. This latest addition provides a summary of selected cells in a grid or view, visible in the page title section, which includes information such as 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 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 DBRW slice
| Status | ||||
|---|---|---|---|---|
|
In the version 2023.05 users also have an option to Export to Excel as DBRW slice 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 DBRWslice under the export button for specific reports.
export as dbrw - exported as not static values but references to cells displayed in report. Those references allow to dynamic pull data from the tm1 server. For this functionality to work as expected user needs to have an excel add-in installed (e.g. Slice) and connection to the server configured. Exported excel file will include filters section.
| Aura divider | ||||
|---|---|---|---|---|
|
Sandbox
| 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 undone, all updates made under a specific sandbox are removed, so it’s recommended to use cube names when creating sandboxes to ease tracking and management.
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 | ||||
|---|---|---|---|---|
|
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 provide users with a variety of customization 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 tooltip.
One of the key benefits of the updated series section is the 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 updated 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 advanced options are available in the advanced options panel, to view the full list please visit 2023.05 » New Control Parameters article.
| Aura divider | ||||
|---|---|---|---|---|
|
Subset Editor
| Status | ||||
|---|---|---|---|---|
|
» new button to Replace Unique Name » remove consolidations information from member definition
two new buttons to show: All Elements or 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 | ||||
|---|---|---|---|---|
|
enable the HTML snippet menu in the widget header » this means that users can now make necessary changes to the snippet code without having to close the popup. This feature saves time and allows users to work more efficiently.
for subnm type parameters, users now have the option to disable hierarchy and indentation » customize the presentation of the data
new column for default values and a toggle button that can force them to be auto-populated in the TI process » reduces the likelihood of errors
| Aura divider | ||||
|---|---|---|---|---|
|
Rollup Class
| Status | ||||
|---|---|---|---|---|
|
This new class can be defined and customized by users, and it will be automatically applied to new consolidated elements and all corresponding cells.
Can be also added in the default cons tunder table section and then the user can decide whether the class should be applied for the specific view / grid widget