Release Notes - What's new in Kyvos 2024.1.x

Kyvos 2024.1.x Releases

Here’s a list of Kyvos versions for the Kyvos 2024.1.x releases:

• Kyvos 2024.1.3 - Features and enhancements

• Kyvos 2024.1.2 - Features and enhancements

• Kyvos 2024.1.1 - Features and enhancements

• Kyvos 2024.1 - Features and enhancements

Features and enhancements for 2024.1.3

Kyvos 2024.1.3 release brings the following new features, enhancements and bug fixes.

• Support of Measure ID through REST API: With this release, users can now use measure IDs to add or update calculated measures in a workbook using the REST API.

• Upgraded JRE version: In this release, Kyvos has upgraded the JRE from version 8.372 to version 8.412.

  • The supported Corretto JRE version for Server is 8.412.08.1

  • The supported Corretto JRE version for Client is 17.0.6.10.1

  • The supported Corretto JRE version for Kyvos Manager is 17.0.6.10.1.

• Upgraded Apache Tomcat version: In this release, Kyvos has upgraded the Apache Tomcat for:

  • Kyvos Manager: 10.1.24

  • Kyvos: 10.1.24

Features and enhancements for 2024.1.2

Kyvos 2024.1.2 release brings the following new features and enhancements.

• Configure expiry date for secret keys in Azure via property: With this release, Kyvos sets the expiration date for secret keys in the Azure cloud environment. However, users can modify the expiry date for the secret keys by using the SECRET_EXPIRY_TIME under global.properties on the Kyvos Manager.

• Support for displaying parameter filters in the 'Show Info’ dialog box: The Kyvos 2024.1.2 brings an enhancement that enables users to easily identify the parameters that are applied on a worksheet or dashboard. With this release, the parameter filter will be displayed in the 'Show Info' dialog box when it is applied to a sheet or dashboard. This will help users to view and manage the parameters more effectively.

• Kyvos Excel Add-in enhancements:
  The Kyvos 2024.1.2 release comes with the following enhancements to the Kyvos Excel Add-in:

  • Support for member properties in grids for user-defined and system member properties: The Kyvos 2024.1.2 release has added support for member properties in grids for user-defined and system member properties.

  • Support for FreeForm Report: With the Kyvos 2024.1.2 release, users can now convert the existing grid to a Freeform reports.

Features and enhancements for 2024.1.1

Kyvos 2024.1.1 release brings the following new features and enhancements.

Kyvos Analytical Store Enhancements

The Kyvos 2024.1.1 release comes with the following enhancements to the Kyvos Analytical store:

• Support for enabling Kyvos Analytical Store via property: The Kyvos 2024.1.1 comes with a new property under global.properties on the Kyvos Manager. This property allows users to enable the Kyvos Analytical Store. Additionally, when the value of this property is set to Yes, and the Query Engine JVM configuration is set to Auto, Kyvos automatically calculates the memory required for the Kyvos Analytical Store.

• Enhanced automatic Query Engines' memory configuration: With this release, Kyvos brings enhancements to Query Engine JVM configuration for Auto mode. If the Auto mode is selected, Kyvos intelligently calculates the Query Engine’s Heap, Off Heap, and Kyvos Analytical Store memory based on the total memory of the Query Engine machine.

• Support for additional Operating System: This release comes with support for additional Operating Systems for Kyvos Analytical Store. For further details, see the https://kyvosdocumentation.atlassian.net/wiki/pages/createpage.action?spaceKey=KD20242&title=Kyvos%202024.1%2C%202024.1.1%20and%202024.1.2%20-%20Supported%20environments%20and%20applications&linkCreation=true&fromPageId=160137554 section.

Features and enhancements for 2024.1

Kyvos 2024.1 release brings the following new features and enhancements.

Kyvos Analytical Store Enhancements

The Kyvos 2024.1 release comes with the following enhancements to the Kyvos Analytical store:

• Support for Decimal type measures: The Kyvos Analytical store efficiently stores, retrieves, and queries big decimal measures created via Kyvos.

• Kyvos Analytical Store statistics: With this release, users can now see Kyvos Analytical Store statistics on the Activity Monitor. To view the Kyvos Analytical Store information, navigate to the Activity Monitor, then click the Query Engine. A detailed view dialog box is displayed. The dialog displays the total number of available Analytical Store connections and the number of connections currently being used. Users can also check the total amount of memory available and the percentage of memory used.

• Support for Parent-Child Hierarchy (PCH): With this release, Kyvos supports processing and browsing the semantic models, having a parent-child hierarchy, alternate hierarchy, and custom rollups in the Kyvos Analytical Store.

• Support for attribute level smart aggregates: This release supports attribute level smart aggregates in Kyvos Analytical Store.

Generative AI-driven Calculation Designer Enhancements

Kyvos has released an enhanced GenAI-driven service named Ask Kyvos Copilot. The copilot helps semantic model and report designers in generating MDX calculations based on natural language descriptions.

The Kyvos 2024.1 release comes with the following Ask Kyvos Copilot enhancements:

• Auto-correcting an MDX expression: The Copilot can auto-correct the MDX expressions by validating the name and syntax of dimensions and measures against the semantic model.

• Selecting category to create MDX expressions: Users can choose the type of category needed for calculations, such as General Calculations, Arithmetic Calculations, and Time-series Calculations.

• Viewing history: Users can access the history of the last 30 days, which can be filtered by category or custom text. To create new expressions, users can reuse previous inputs and outputs automatically by clicking the 'Use me' option. Alternatively, they can manually fill in the input by clicking 'Copy to Clipboard' to regenerate it.

• Configuring Kyvos Copilot connection: Users can now configure Kyvos Copilot connection through Kyvos Manager.
  See the GenAI Configuration for more details.

Kyvos Excel Add-in Enhancements

With this release, Kyvos supports the replacement of the '0' value with the 'Null' feature in Kyvos Excel Add-in when fields are present in rows and columns.

Rebalance aggregates via Kyvos Web Portal

With the Kyvos 2024.1 release, users now have the option to rebalance aggregates directly from the Kyvos Web Portal. Unbalanced aggregates among the Query Engines can adversely affect query performance; hence, users should consider rebalancing the aggregates as and when needed.

Result Cache Mechanism Enhancement

In the Kyvos 2024.1 release, there is an enhancement to the result caching mechanism for MDX queries. This improvement involves the implementation of a queue-based mechanism to cache results, preventing the Kyvos application from becoming unresponsive.

Kyvos Manager Enhancements

• Kyvos Manager High Availability: With the Kyvos 2024.1 release, users now have the option to enable Kyvos Manager high availability. This means that another service will be activated immediately to meet the requirements in the event of a service failure. To enable Kyvos Manager High Availability, set the value of the ‘ENABLE_KM_HA’ property to ‘yes’ from the Kyvos Manager Properties page.

• SAML2-based external authentication for Kyvos Manager: This release supports SAML2 configuration between identity provider and service provider, particularly for security assertion, which is already supported in the Kyvos Web Portal for authentication.

• Exporting Cluster Operations to CSV (Comma-Separated Values): With this release, users can now export the list of cluster operations to CSV format. This enhancement streamlines data management and analysis, providing users with a user-friendly way to save and share cluster operation data.

Performance Enhancements

Session Set Query Enhancements

The Kyvos 2024.1 release introduces the ability to facilitate the pushdown of MDX expressions, such as aggregate over set, where a scalar entity is not provided to Query Engines, enhancing query performance for session set queries. Currently, this support is extended to cases where measures from a single fact are present in query. Previously, when executing cohort cases using session set queries to evaluate aggregates over the session set, slow query performance was encountered due to row-wise execution for each row in the view.

Cloud Support Enhancements

Azure Enhancements

• High Availability of Kyvos Services Instances and Storage Account: This release has added support for deploying the BI Server, Query Engine, and Web Services across multiple availability zones in Azure, as well as configuring a Zone-redundant Storage Account (ZRS) to ensure high availability of Kyvos Services.

• BI Server nodes scaling in Azure Marketplace: Users can now increase or decrease BI Server nodes via scaling from Kyvos Manager on the ‘Node and Service Mapping’ page.

• Fixed new recommendations by Azure Defender: This release has fixed the following recommendations provided by Azure Defender:

  • Included content type in the Key Vault Secret.

  • Added client certificate in the Azure Functions.

• Disaster Recovery and backup on Azure: Kyvos now supports disaster recovery for its components in Azure. To enable disaster recovery in Azure, users can choose the recovery options available for respective services in Azure Cloud. However, users need to perform manual disaster recovery and backup steps on Azure. Additionally, ensure that disaster recovery in Azure is only supported when an external Postgres repository is used for Kyvos.

Usability Enhancements

• Query failure reasons: With this release, Kyvos comes with the ability to show 'Failure Reason' on the built-in Historical Query Details dashboard. This column shows the details of the reasons leading to query failures.

• User name information in Snowflake queries: The Kyvos 2024.1 release has comes with the ability to identify the user executing queries on Snowflake. Using this feature, the administrators can now identify the Kyvos user who executed a query on Snowflake. To enable this, set the value of the kyvos.connection.sql.addcomment property to ‘true’ at the Snowflake connection level.

Kyvos Viz Enhancements

• Retrieve Job Details as HTML: With this release, downloading logs from the Job Summary page includes an HTML file containing details of the jobs executed on the cluster.

• Row Level Security with ‘OR’ condition: Users can now create conditional Row-level data security rules using both "AND" and "OR" conditions.
  NOTE: Previously, the 'AND' condition was implemented by default. Now, users can choose between 'OR' and 'AND' conditions.

• Migration of Treemap charts from D3 to Amchart 5: With this release, the Treemap charts are migrated from the D3 library to Amchart 5. With this migration, users can now select layouts in Treemap charts within Kyvos Visualization for worksheets. These layouts include Square, Horizontal, Vertical, and Horizontal followed by Vertical.

Web Accessibility Enhancements

Continuing with our commitment to the inclusion of its customers and users with disabilities. We are taking steps to help ensure that the Kyvos Web application and our customers’ experiences adhere to WCAG 2.1 Level A and AA standards. As a result, the Kyvos 2024.1 release comes with the following enhancements:

• Accessibility in Kyvos Viz. charts

  • Supported the following in Kyvos Viz. for table

    • Keyboard Navigation:  

      • Users can navigate across table elements using the tab key and arrow keys.

      • Users can use the context menu shortcut (ctrl + shift + M) on focused table elements if the context menu is available. 

    • Aria Label and Role (Name, Role, Value A 4.1.2):  

      • Table elements have role and aria-label attributes. These are used by assistive technologies to enhance accessibility.  

  • Supported the following in Kyvos Viz. for crosstab

    • Keyboard Navigation:  

      • Users can navigate across crosstab elements using the tab key and arrow keys.

      • Users can use the context menu shortcut (ctrl + shift + M) on focused crosstab elements if the context menu is available. 

  • Supported the following in Kyvos Viz. for KPI

    • Keyboard Navigation:  

      • Users can navigate to KPI using the tab key.

      • Users can use the context menu shortcut (ctrl + shift + M) on focused KPI if the context menu is available. 

    • Aria Label and Role (Name, Role, Value A 4.1.2):  

      • KPIs have role and aria-label attributes. These are used by assistive technologies to enhance accessibility. 

  • Usability improvements per rule: 3.3.1 Error Identification (Level A) in Kyvos Viewer. 

API Enhancements

This release comes with the following API enhancements:

• New Rest API added to the Kyvos 2024.1 release:

  • Get Semantic Model SQL Metadata: To get SQL metadata of a semantic model.

• New parameters have been added to the following existing REST APIs:

• Enhancements to the following existing REST APIs :

  • Create Data Security Rules: To use Row Level Security with the ‘OR’ and 'AND' conditions. The API also supports providing comma-separated values while creating rules.

  • Execute Query: To execute MDX queries and SQL queries with Rest API.
    NOTE: In this release, the REST API endpoint has been changed from \export\executeQuery to \export\query.

For further details, please see the REST API guides.

New Properties

This release comes with the following new properties:

• New Kyvos Manager Properties added to the Kyvos 2024.1 release:

  • ENABLE_KM_HA: To enable or disable Kyvos Manager High Availability (HA) mode from Kyvos Manager Properties page.

  • CREATE_USER_ON_KYVOS_SSO: To determine whether to create a user in the integration mode of Kyvos Manager and Kyvos if the user is not present in Kyvos Manager.

  • CREATE_USER_ON_THIRD_PARTY_SSO: To determine whether to create a user who doesn't exist for Third-Party SSO (OIDC and SAML2).

• kyvos.connection.sql.addcomment (Connection property): To include the username in the Snowflake query as a comment in the SQL statement.
  NOTE: This applies only to the Snowflake connection.

Behavior Changes

• Seamless Kyvos Security Configuration without restarting Kyvos Web Portal: With this release onwards, the Kyvos security configuration (Web-based SSO) can be implemented without the need of restarting the Kyvos Web Portal.

• Migrating Storage account TLS version from 1.0 to TLS 1.2: From Kyvos 2024.1 onwards, for fresh deployments on Azure, the minimum TLS version value must be 1.2. When upgrading, users must perform post-deployment steps to migrate from TLS 1.0 and 1.1 to TLS 1.2 through Azure Storage Accounts.
  NOTE: As of November 1, 2024, Azure Storage no longer supports TLS 1.0 and 1.1, and it is essential to migrate to TLS 1.2 version.

• Seamless Kyvos Security Configuration without restarting BI Server: With this release, the process of configuring Kyvos security for LDAP, Active Directory integration, and Single Sign-On has been streamlined. Frequently modified fields will be updated seamlessly without restarting the BI server by choosing the Incremental option from the User Group Sync Level list. To know more about Kyvos Security Configuration, see the Kyvos Authentication section.

  NOTE: The BI Server restart will only be required when updating fields for the first time.

• Exclusion of History Audit and Querying Audit semantic models: The Kyvos 2024.1 release has temporarily removed the built-in 'History Audit' and 'Querying Audit' semantic models that were used to view Kyvos auditing logs. However, you can still view data for the last 30 days on the 'Activity Monitor' by clicking the Audit Logs tab.
  NOTE: If you need to access data that is older than 30 days, it is stored in the Distributed File System (DFS), and you can design and process a semantic model based on it.

Read more