Release Notes Incorta Cloud 2024.1.3

Release Highlights

In this maintenance pack:

• Relaxing the lookup function validation
• Multiple default groups by dimensions in Aggregated Tables
• Dynamic Pivot Table Analysis
• Wrap the label text in the Dual X-axis chart
• Export current dashboard state
• Improved handling of cyclic dependencies in variables
• Querying non-optimized tables via Advanced SQL Interface

Relaxing the lookup function validation

The validation on the lookup() function introduced in 2024.1.0 is now relaxed to allow:

• Using columns from business schema views with columns from the source physical schema object in the same expression
• Limiting the validation to creating new or updating existing expressions
• Existing expressions where the result lookup field and primary key field parameters are not from the same object or its business schema views not to return an #Error value

Multiple default groups by dimensions in Aggregated Tables

The dynamic group-by is a powerful feature in Incorta's Aggregated Tables. In the latest update, users can override the default grouping behavior in which the first dimension in the grouping dimension tray is displayed. Instead, users can select which grouping dimension(s) to show as a default for dashboard consumers.

Dynamic Pivot Table analysis

In this release, pivot tables have added two powerful enhancements:

• The ability to define a dynamic group by logic (previously only available in aggregated tables)
• The ability to define dynamic columns

As a result, users can interactively select and de-select rows and columns to display in their pivot table. As a bonus, these two new features also allow users to set a default view.

Wrap the label text in the Dual X-axis chart

There is now a new lab format option to wrap the text label for the Dual X-axis chart. This format option applies to the upper X-axis. You can keep the original behavior, where the text exceeding the reserved area of the label is trimmed, or toggle label wrapping in the pill settings.

Export current dashboard state

Incorta can now export dashboards for PDF and HTML in their current view state in this release instead of reverting to their default state. The following actions supported from an end-user interaction that can be exported are:

• Sorting
• Dynamic Group By (in tables)
• Dynamic Measures (in tables)
• Dynamic Fields (used in measures)

If a dashboard consumer has used the above actions before exporting, the exported in a direct or scheduled dashboard export will reflect their changes. When exporting the dashboard, under the Choose Bookmark option, you can select existing bookmarks or “Current Dashboard State”. Note that dashboard states have the option to save to bookmarks.

Improved handling of cyclic dependencies in variables

This enhancement focuses on improving system resilience and stability by resolving issues related to infinite loops and overflow exceptions caused by cyclic dependencies in variables. However, it's essential to acknowledge that a standardized error message or expected output has not yet been established. Users may encounter varied outputs, including #Error, 0 rows, empty strings, or variable name displays, depending on the context. Ongoing efforts are dedicated to achieving uniform error handling and output consistency.

Querying non-optimized tables via Advanced SQL Interface

Non-optimized tables can now be accessible via the Advanced SQL Interface. As a result, external tools, such as Tableau and Power BI, can now discover and query non-optimized tables that do not have any of the following:

• Security filters
• Formula columns
• Encrypted columns

Contact Incorta Support to help you configure your cluster.

Enhancements