Page tree
Skip to end of metadata
Go to start of metadata

New features and enhancements

Smart aggregates enhancements

The Kyvos 2020.4 release brings enhancements to the Smart Aggregates feature.

  • Users can now select properties to optimize the cube build time and size from the Smart Aggregation Strategy screen.
  • Users can also choose recommendations for Physical view, Partitions, and Advance Properties.
  • Besides this, two new recommendation modes – Smart and Expert are also introduced. Using these modes, users can choose the aggregations strategy.

Audit Logging enhancement

With Kyvos 2020.4 release, the audit logs are maintained in an additional file on the BI server machine. Each BI Server has its own separate file containing the audit information.

Cloud deployment enhancements

Support for integrating Azure Active Directory

Kyvos 2020.4 release provides an additional security option for vault-based deployment where Kyvos will store the LDAP password in Azure Key Vault and read the password from Key Vault if the vault is configured.

Support of Validation of installation prerequisites for AWS

Kyvos 2020.4 release can detect and validate if all the prerequisites for AWS installation are available. The deployment will start only if all the prerequisites are fulfilled. This ensures that users don’t waste time and resources in failed deployment due to incomplete prerequisites.

Enhancements in Azure Resource Manager template-based deployment

    • You can now deploy the cluster using the Kyvos Manager war bundle.
    • Kyvos 2020.4 support vault creation in the automated and wizard-based deployment. If no Key vault URL is provided for Azure secrets, Kyvos will create a new vault automatically.
    • The ARM template can now create VNet peering between Kyvos VNet and Databricks cluster VNet
    • The ARM template now allows users to use an existing custom image of their Azure environment for deployment.
    • The ARM template can also create Azure functions, such as functions for start BI servers, forced start of BI server, and fetch cluster status. 
      NOTE: If using the wizard-based installation, users can choose to use their own externally created functions.

Security enhancements

Automated setup for TLS with Mutual Authentication

Kyvos 2020.4 release brings added support in Kyvos Manager to automate the manual steps for configuring TLS with Mutual Authentication. Users can now upload certificates with relevant details from Kyvos Manager. The system will automatically configure all the components with TLS as selected by the user.

Kyvos repository password security

Kyvos uses a relational database to store the metadata pertaining to entities in the product. Postgres database is currently used as a repository database. To enhance security Kyvos 2020.4 comes with the following features to manage the repository password.

  • Users can now change the default repository database password.
  • Kyvos will store the password in Azure Key Vault and read the password from Key Vault for desired operations.

Support for custom Kyvos row-level security

Kyvos 2020.4 now allows users to define callback code to provide custom row-level security depending on their business requirements. This allows users to conditionally restrict access to fields.

Optimize query performance on ROLAP/HOLAP

The Kyvos 2020.4 release comes with enhanced query preprocessing time for ROLAP/HOLAP cubes optimized by leveraging object cache.

Calculated measures and members in MS Excel

Kyvos 2020.4 allows users to create calculated measures and calculated members in MS Excel and browse them using the Kyvos cube. All the Excel-specific calculated measures and calculated members will be valid only for the current session.

User experience improvements 

Kyvos 2020.4 release comes with user experience enhancement so that users can quickly work through Kyvos.

Highlight the currently running schedule in scaling schedules

Kyvos now highlights the currently running schedule on the Cluster scheduling page allowing the users to quickly identify the schedule.

Add notes/comments for each cube build instance

Users can now add notes/comments on each build version and this information is visible at the manage build instance screen. Users can view this information at the Manage Build Instances screen.

Cache strategy UI enhancement

With Kyvos 2020.4 release, the Cache strategy option is moved to the refine tab of the cube designer. Further, the changes in Cache strategy rules will be saved with the associated designer’s save button.

Access right notification

When working on an entity in the cube designer screen, the users will not be notified if they do not have the access rights on it. This shows a read-only notification message, and any changes made by the user on such entities will not be saved.

Custom filter list

Kyvos users will now have the ability to add a list of comma-separated values to filter. The user can opt for a custom list on value popover, for using this feature. The filter will apply to all the selected values, whether they are present in the pre-defined list or not.

Platform migration

The Kyvos Visualization module is now migrated from AngularJS to Angular 9.

Changes in default properties values

With Kyvos 2020.4, the default value for some properties is changed. The following table provides a list of the properties along with the updated values.

Property name


Old Value

New Value


Specifies the amount of off-heap memory per executor when jobs are executed using Spark.




Specifies the amount of memory per executor when jobs are executed using Spark15 GB20 GB


Specifies the amount of memory to be used for the driver process, i.e. where SparkContext is initialized.

5 GB10 GB

Behavioral changes

With the Kyvos 2020.4 release, users will see a change in the behavior of certain UI elements. Here’s a list of what has changed.

Kyvos Visualization

  1. The Auto chart-type is now removed. Any previously created auto charts will be shifted to their actual chart-type.
  2. On creating a new sheet, Crosstab will be the default visualization.
  3. Users can now create Tree-map and KPI using the Custom Visualization framework.
  4. Changing a visualization to a line/curve chart, will not place the time type dimension on X-axis, as was done in the previous releases.
  5. While changing the cube for a worksheet, all dimensions and measures are searched by name only. They will not be searched by the ID as 
  6. If the cube corresponding to a worksheet is deleted, the sheet will not open unless the user selects a new cube. Users will get the option of selecting a new cube using the Change Cube button in the banner.
  7. If a user drills down any member in a chart and changes the visualization to the crosstab, then the drill-down state won't be reflected in the crosstab.
  8. When a member is expanded on Crosstab in classic view, the header drag and drop is disabled.
  9. Users cannot perform any operation on the summarized view of a chart. This view will open in read-only mode.
  10. The color picker used in the Highlight dialog is changed.
  11. The value input for conditions in the Highlight dialog is now shown in a popover, just like other filters on the Filter panel.
  12. Removed support for is in top and is in bottom in highlight. Existing worksheets (saved before Kyvos 2020.3) with TopN highlight, will now open without TopN highlighting.
  13. Data (for chart and crosstab) caching is removed from the indexDB.

Filters in Worksheet

  1. Filters are divided into three categories: Dimension Filters, Contextual TopN Filters, and Measure Filters.
  2. Quick filters are renamed to Dimension filters.
  3. Moved Advance and TopN filters to Filter panel as Measure and Contextual TopN filters respectively.
  4. Changed Advance and TopN filter's UI as a Quick filter format.
  5. When no filters are added, by default every filter section has an empty filter in place.

  6. Add and remove options are provided on each filter row.

  7. Users can now drag measures from the Measure listing panel to the Filter panel to add a default Measure filter.

  8. Measure filters are implemented in two modes:
    1. Simple: Filter having only field, criteria, and value selection enabled. By default, the relation is set as ‘and’. Users can click the three-dot menu to clear or switch to the Advanced filter.

    2. Advanced: Filter having open brackets, field, criteria, value, closing brackets, and relation selection enabled to provide users the flexibility of creating complex filter queries. Users can click the three-dot menu to clear or switch to the Simple filter.

  9. Advanced Filters (Measure filter) and TopN filters (Contextual TopN filters) can now be suspended too, as Quick filters (Dimension filters).
  10. For Measure filters, By Field, and By Value options are moved inside value popover, which opens on value selection.

  11. Users can view or hide all three filter sections (can be hidden only if filters are empty), through the Filter panel context menu.

  12. Users can now apply filters manually or automatically, through the option provided from the Filter panel context menu.

  13. All filters can be switched between Simple mode and Statement mode from the Filter panel context menu.
  14. Each filter section can be cleared through the option provided on the context menu for each filter section.

Dashboard changes

1. In a fixed layout, new cards will be added in a vertical direction first, then in the available space horizontally.
2. The cards showing No data available are now displayed in a minimum size according to screen size if it is set as hidden from the properties panel.

Access rights changes

If a worksheet is shared with read and write rights, and the parent workbook is shared as read-only, then the user will not be able to save this worksheet unless the workbook is shared with read and write access to the user.
All such worksheets will be marked by read-only tag and the behavior will be as same as read-only sheets. 

Custom chart migration

HTML Control

This control is used to show/hide a group of widgets in the Dashboard. As this functionality is achieved by a group card, this visualization is deprecated in the migrated viewer.

For Backward compatibility, the HTML Control code is updated to show the following message.
“This visualization is no more supported from product version 2020.4. Please migrate to group card feature to achieve the same functionality in Dashboard”.

Users can open the corresponding sheet and Dashboard and update them.

Image Control

Image Control is migrated to the new visualization and will work with Migrated Viewer.

Divide operation on Calculated measure

The Kyvos 2020.4, comes with some changes in the behavior of Divide operation in Calculated Measure:

  • If the Denominator is 0, Null, or Empty and the alternate result is provided, then the alternate result is returned,. Otherwise, a blank value is returned.
  • If only the numerator is 0, Null, or Empty, then the value will be 0.00 as it will perform an operation (0.00/Denominator = 0.00).

Smart recommendations

As mentioned above, this release brings two exclusive aggregation strategy modes to build a cube: Smart and Expert 

As these modes are exclusive in terms of user inputs, it will bring the following behavior changes with respect to 2020.3.

  1. Change in Aggregation Strategy mode (expert to smart or vice versa) will not work with Incremental or Update Aggregates build. This requires a Full cube build.
    Reason: It may happen that dimension materialization that system has recommended internally vs. what the user has set may be different.
    This means a use case where you initially start with expert mode and then want to add a few additional aggregates to improve certain slow queries will not work.
  2. Accepting Aggregates with Smart mode may not work with an incremental build, as the dimension materialization property may change internally after accepting new aggregates recommendation. Accepting Incremental aggregates in Smart mode will continue to work in updating aggregates and incremental build.
  3. In Smart mode properties (dimension and hierarchy materialization) recommendations are implicit. A User has no way to control which dimension and hierarchy to materialize.

API enhancements


The Rest APIs added for the Kyvos 2020.4 release are:

  • REST API to get Data Security Rules Mapping.
  • REST API to assign different sets of rules to different sets of users and groups through a single API Call.
  • REST API to add multiple data security rules in a single API call.
  • No labels