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

• Kyvos 2024.3.3 - Features and enhancements

• Kyvos 2024.3.2 - Features and enhancements

• Kyvos 2024.3.1 - Features and enhancements

• Kyvos 2024.3 - Features and enhancements

Features and enhancements for 2024.3.3

The Kyvos 2024.3.3 release introduces the new features and enhancements:

• No-Spark Wizard-Based Deployment for GCP: For Wizard-based deployments, Kyvos now supports the use of No-Spark (Kubernetes (K8S) as the compute engine to process semantic models on GCP.

Features and enhancements for 2024.3.2

The Kyvos 2024.3.2 release introduces new features and enhancements:

• Kyvos Modern Architecture with No-Spark Ingestion Enhancements
  The Kyvos 2024.3.2 release comes with the following enhancements to the No-Spark Ingestion.

  • Support for Changing Default Compute Cluster: Kyvos now offers the flexibility to switch from an external compute cluster to Kyvos Native for processing semantic models using Kyvos Manager on the Compute Cluster page. Moreover, you can enable scaling (AWS and GCP only) for the compute server on this page. This functionality is applicable across all cloud environments (AWS, Azure, and GCP).
    NOTE: Switching to the External Compute cluster is not supported if Kyvos is deployed with the Kyvos Native compute cluster.

  • No-Spark Wizard-Based Deployment for AWS: For Wizard-based deployments, Kyvos now supports the use of No-Spark (Kubernetes (K8S) or Shared Query Engines) as the compute engine to process semantic models on AWS.

  • Kyvos now supports MSSQL connectivity for browsing ROLAP semantic models using MDX and SQL.

  • No-Spark Java configurations through Kyvos Manager: Kyvos now offers the flexibility to specify memory allocations for Kyvos Analytical Store for querying via Kyvos Manager on the Java Options page. Additionally, users can set the heap memory for compute servers running on Shared Query Engines or Kubernetes (K8S).

  • Download No-Spark logs: Users can now download no-spark logs through Kyvos Manager on the Monitor > Log Files > Archived page. Users can obtain logs for any specific nodes and also apply a date filter to fetch more precise log details.

• Seamless Kyvos Manager Access via Kyvos SaaS Portal: Users can now fully access Kyvos Manager through the Kyvos SaaS Portal if permission is granted by administrators.

• OAuth Authentication for Databricks SQL Warehouse: Users can now authenticate using OAuth when connecting to the Databricks SQL Warehouse.

• Metadata Processing Control for Attributes: Kyvos now supports managing attribute metadata processing through the Kyvos Web Portal.
  NOTE: It is only supported with SQL.

• Configure azcopy command parameters: Users can now set the required parameters for the azcopy command in systemconfig.json file.

• Handling Unresolved Identifier for MDX-Based Querying: For MDX-based querying, if a member, filter, or calculated expression is missing due to changes in the underlying data, Kyvos can now ignore the missing member while serving the query instead of throwing an error. This is configurable through semantic model-level property, and users can decide whether to render the data ignoring invalid members or see an exception at the time of querying. By default, Kyvos will now ignore the missing member.

• API Enhancements: New Rest API added to the Kyvos 2024.3.2 release:

  • Member Column Search: To fetch member column details of a level or attribute from a semantic model.

  • Fetch Column Data: To fetch the column list of a level or attribute in semantic model.

Features and enhancements for 2024.3.1

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

• Hierarchy materialization with smart aggregates for parent-child and alternate hierarchies: Kyvos now supports creating smart aggregates for parent-child and alternate hierarchies, providing improved query performance by eliminating the need to join tables at query time.

• Support for searching 'calculated members' in Excel add-in (XLcubed) while designing a grid: Users can now search for calculated members' in Excel add-in (XLcubed) while designing a grid.

Features and enhancements for 2024.3

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

Announcing Kyvos Modern Architecture with No-Spark Ingestion (Beta)

Kyvos modern architecture is based on two significant enhancements made in Kyvos.

First, a modern querying layer with a high-performance Analytical Store to further enhance query performance at a reduced cost. Second, No-Spark Ingestion capabilities. With these, we are able to eliminate dependency on traditional spark jobs and external compute engines such as Databricks, Dataproc, or EMR for processing semantic models and building aggregates.

Users can now use the Kyvos Native compute engine for semantic model processing.

Kyvos now comes with the following Native compute options:

• Shared Query Engine: In this mode, the Query Engines serve queries as well as handle the semantic model processing. This dual role is named SHARED as the same process performs both activities.

• Dedicated Compute Server: In this mode, the semantic model is processed via dedicated service. For cloud-based deployments, the semantic model is processed using Kubernetes (K8S) cluster-based nodes while for On Premises environments, semantic models are processed on dedicated nodes.

For further details, see the No-Spark Semantic Model Processing through Kyvos Native Compute Engines section.

For Kyvos version 2024.3, the Kyvos Modern Architecture supports the following features with no-Spark ingestion:

• No Spark and No Hadoop processing for on-premises Kyvos deployments.

• Browsing ROLAP semantic models using MDX and SQL.

• Using Azure SQL database connection for no-Spark processing of semantic models.

• Optimized level of detail (LOD) queries when querying on a single fact.

• Ability to select a compute engine such as Kubernetes or Kyvos Query Engines when deploying Kyvos via Azure Template Specs.

• Ability to dedicate compute servers for compute-based semantic model processing. Additionally, users can also monitor the number of Compute Servers from the Kyvos Web Portal on the Monitor page.

• Downloading Compute Server and Compute Server Pod logs for cloud (AWS, Azure and GCP) deployments. Users can also select the number of days for which they want to download logs.

Support for XIRR function in MDX

Kyvos now supports XIRR function in MDX that returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. For further details about formula syntax and usage of the XIRR function, see Microsoft documentation.

Upgraded Apache Tomcat version

Kyvos has upgraded the Apache Tomcat version for Kyvos Manager and Kyvos to 10.1.25.

Kyvos Manager Enhancements

• Support for managing roles: Administrators can now create roles and assigning role privileges to Kyvos Manager users through Kyvos Manager.

• Support for role mapping: Kyvos now comes with automatic mapping of user roles across Kyvos and Kyvos Manager, ensuring users receive the correct privileges and access.

Cloud Support Enhancements

The Kyvos 2024.3 release comes with the following enhancements for AWS and GCP deployments:

NOTE: This capability was earlier available only for Azure deployments.

• Single-click upgrade: User can now upgrade both Kyvos and Kyvos Manager applications to a newer version by simply selecting the required version from the Kyvos Manager portal. For further details, see Upgrading Kyvos Manager and Kyvos.
  NOTE: The single-click upgrade feature is also available for on-premises upgrades.

• Version-based upgrade: Users can now select a specific release version and quickly upgrade Kyvos and Kyvos Manager from the Kyvos Manager portal.

• Version-based patch deployment: This Users can now for select a specific Kyvos patch versions for patch deployment from the Kyvos Manager portal.

Azure Enhancements

• Seamless Kyvos and Kyvos Manager upgrade and patch deployment without a secret key

  • With this release,

    • Users can streamline the upgrade process for Kyvos and Kyvos Manager by selecting the applicable release versions through Kyvos Manager, thus removing the need of adding a secret key.

    • Users can select patch versions for patch deployment through Kyvos Manager, streamlining the process by eliminating the need to add a secret key.
      NOTE: The Licensee ID must be registered to obtain the version listing.

• Upgraded azcopy version: The azcopy version is now upgraded form 10.16 to 10.25.
  NOTE: To upgrade the azcopy version, users must execute the post-upgrade steps on every Kyvos node, including the BI Server, Query Engine, Kyvos Manager, and Web Portal.

• Support for Databricks 14.3 LTS version for Azure clusters

AWS Enhancements

• Support for selecting Kubernetes as a compute engine: Users can now use Kubernetes (K8S) as a compute engine to process no-Spark semantic models.

• Upgraded AWS RDS PostgreSQL version: The AWS RDS PostgreSQL is upgraded from version 13.11 (EOL November 2025) to 16.3.

• Support for reading cuboids from AWS S3 in Kyvos Analytical Store

• Support for prepaid Query Engines and Cache Storage: For AWS Managed Service cluster, Kyvos now comes with the support for prepaid Query Engine and Cache Storage through Kyvos license.
  NOTE: If you exceed the prepaid limits and add more Query Engines or cache storage, you will be charged based on your usage.

Kyvos Viz Enhancements

• Support for floating widgets: Kyvos now supports floating widgets on the Kyvos Viz dashboards enabling users to effortlessly move, resize, and rearrange widgets for a more intuitive experience. This flexibility empowers users to prioritize critical data and visualizations based on their business needs, while liberating them from the limitations of a fixed layout and dashboard workflow.

• Access worksheet and Dashboard on mobile device: This release has added support for accessing worksheet and Dashboard on mobile devices.

API Enhancements

This release comes with the following API enhancements:

• Kyvos Manager REST API Authentication Enhancement: The Kyvos Manager REST API authentication mechanisms are enhanced to improve the security, usability, and integration capabilities, providing a more robust and versatile solution for managing and interacting with Kyvos deployments.

  • OAuth Authentication: Users can now authenticate the REST API using OAuth, providing a secure and standardized method that integrates seamlessly with various identity providers

  • Session Key-Based Authentication: In addition to OAuth, Kyvos has implemented session key-based authentication, offering an alternative method for secure access.

  • Basic Authentication: The existing basic authentication method continues to be supported, ensuring backward compatibility and ease of use.

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

For further details, please see the REST API guides.

New Properties

This release comes with the following new properties:

• New Kyvos Manager Property added to the Kyvos 2024.3 release:

  • NEW_CREATED_USER_DEFAULT_ROLE: To set roles for newly created users through SSO login and displays all Kyvos Manager roles.

Behavior Changes

• Implementation of ‘percentile_approx’ in Tableau data source files (TDS) and Custom calculation for Power BI (PBIT) file as a default summary function
  Kyvos has now mapped sum and average summary functions to 'percentile_approx' for TDS files and 'custom calculation' for PBIT files. These functions will be the default measures for browsing semi-additive measures, calculated measures, and aggregated measure functions within complex hierarchies upon downloading. This update ensures that all queries are processed exclusively by Kyvos, preventing any incorrect mappings and ensuring accurate totals in BI tools.
  Prior to the Kyvos 2024.3 release, 'distinct count' was the default summary function for semi-additive and calculated measures in Tableau TDS and Power BI PBIT file exports.

Read more