Content Comparison

Here is the list of features and updates included in the Kyvos 2024.9 10 release.

• Feature and Enhancements

• Kyvos Manager Enhancements

• Cloud Support Enhancements

• Kyvos Viz Enhancements

• API Enhancements

• New Properties

Features and Enhancements for 2024.

...

10

Anchor

...

feature feature

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

Conversational Analytics using Gen AI-powered Kyvos Copilot

Kyvos Modern Architecture (No-Spark Ingestion) Enhancements

• Kubernetes Compute Servers Monitoring: Kyvos now supports monitoring both running and pending pods in a Kubernetes-deployed cluster. Additionally, users can easily debug the semantic model process running on Kubernetes pods by downloading the output of kubectl commands directly from the Kyvos Activity Monitor screen.
  For further details, see Monitoring Compute Servers.

• No-Spark Wizard-Based Deployment for Azure: 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 Azure deployments.

• Using Existing Kubernetes Cluster for AWS and GCP Wizard-Based Deployment: Users can use existing Kubernetes clusters as the compute engine for processing semantic models on AWS and GCP deployments.

• Qualify members value for hierarchy: Kyvos now supports configuring the hierarchical member qualification to uniquely identify multiple members with the same name at a given level but with different parent values. With this feature, unnecessary inclusion of levels can be avoided that may impact semantic model processing size, time, and cost. For further details, see Qualify members for hierarchy.

Kyvos Langchain Document Loader Toolkit

Users can now utilize the Kyvos Langchain Document Loader toolkit, which provides a high-speed semantic layer, delivering instant responses to business queries without the need to select a semantic model. This platform-independent tool can be deployed in any environment or through a code editor. After execution, users can seamlessly interact using the 'Converse with your Data interface.

Kyvos ODBC Driver 4.0

Kyvos has come with the Kyvos ODBC driver 4.0, which supports OAuth authentication.
NOTE: The Kyvos ODBC driver does not support OAuth directly and can only be used with third-party BI tools.

Kyvos ODBC Connector

The Kyvos ODBC connector is now available in Microsoft Power BI. Users can use this connector to connect to the Kyvos semantic model through Microsoft Power BI.
NOTE:

• To use the Kyvos ODBC Connector, users must install the Kyvos ODBC Driver version 4.0.

• Starting from the September 2024 release of Power BI version 2.136.1202.0 64-bit, the Kyvos ODBC Connector will be available for use.

• This feature is only supported in Power BI Desktop.

...

• Download Archived Kyvos Services Logs: Users can now download all archived Kyvos Services logs from the Kyvos Manager by navigating to Monitor > Log Files > Archived. Users can also fetch logs for a particular node for a specific date for more precise log details.

• Increase or Decrease Kubernetes Node Pool Maximum Capacity: Users can now increase or decrease Kubernetes node pool by configuring the maximum compute server count.

• Kyvos Manager Restart from Disaster Recovery Page (TLS Enabled): Users can now directly restart Kyvos Manager from the Disaster Recovery page when TLS is enabled on the cluster before performing Disaster Recovery.

...

• Scaling Web Portal, BI Server, and Query Engines Nodes for Kyvos Enterprise deployments: With this release, users can now effortlessly scale BI Server, Query Engines, and Web Portal nodes through Kyvos Manager across Kyvos Enterprise on AWS, Azure, and GCP.

Azure Enhancements

• Encryption Key Rotation Policy for Secure Deployments: Kyvos now comes with a default rotation policy for the encryption key in secure deployments. Users can also configure the rotation policy settings if needed.
  NOTE: These changes are applicable to Azure Enterprise and Azure Marketplace deployments.

• Secret Values in Plain Text: Post deployment, users can now retain secret values in plain text by selecting the 'None' option on the Manage Credentials page through Kyvos Manager.

...

Suspend a Semantic Model: Kyvos now supports suspending unused semantic models. Once suspended, a semantic model cannot be queried or browsed. Users can also resume a suspended semantic model as needed.

NOTE: Selecting a suspended semantic model for use in worksheets, workbooks, or Kyvos Copilot will display an error message.

...

Smart Labels for Date Type Attribute in XY Family Charts: Users can now select smart labeling for date-type attributes in XY family charts. This feature adjusts date values to present the most relevant level of detail. Smart labels facilitate more concise labeling by grouping dates together, thereby enhancing the clarity of the display.

...

Page Breaks While Export Dashboard: Kyvos now supports addition of page breaks while exporting and email scheduling of dashboards in PDF format.
NOTE: Page breaks will not be available in the mobile view.

...

Subtotal for Selected Dimension in Crosstab: Users can now view subtotals for selected dimensions in a crosstab. This feature allows users to control the visibility of subtotals, helping business users reduce clutter in large tables and focus on the most important figures.

...

Configuration for Small number Threshold in Charts: Users can now set the small number threshold for charts via the ‘smallNumberThresholdForCharts’ property present in the portal.properties file.

...

With this release, the Kyvos Copilot comes with truly self-serve Conversation Analytics capabilities by combining natural language input with GenAI-driven functions.

The focus is on simplifying complex tasks and making advanced data analytics accessible to users, regardless of their skill level with query languages.

The Copilot streamlines the creation of essential business calculations, making them easy to understand for users of all abilities. It then converts these inputs into the appropriate query language.

With the Kyvos Copilot, users can interact with data using everyday business language, simplifying critical business calculations. Additionally, it provides natural language summarization of data, enabling quicker insights for data-driven decision-making across the organization.

Conditional Column Masking for No-Spark Deployments (Beta)

With this release, Kyvos introduces conditional column masking for No-Spark deployments. This conditional column masking provides more granular control by masking data in a column based on specified conditions. It enhances column-level security, enabling users to share reports with multiple users without worrying about exposing sensitive data or unauthorized visibility.

NOTE: In this release, conditional column masking is not supported for measures columns.

Kyvos Modern Architecture (No-Spark Ingestion) Enhancements

This release comes with the following no-Spark enhancements:

• Athena as SQL Engine: Kyvos now supports Athena connection for no-Spark (both Shared Query Engine and Kubernetes) to process semantic models.

• Kubernetes Instance Type Change for All Clouds: Users can now change the instance type for the Kubernetes cluster node pool for all cloud deployments (AWS, Azure, and GCP).

• Kyvos Native Support on AWS Managed Services: Kyvos now supports a processing semantic model with no-Spark using the shared Query Engine and Kubernetes cluster.

• Kyvos Native Support for Terraform-Based Deployment in GCP: Kyvos now supports processing semantic model with no-spark using shared Query Engine and Kubernetes cluster for automated deployment Terraform-based deployment in GCP.

• Metadata filtering on Row-Level Security: For Row-Level Security (RLS), Kyvos now respects RLS filters for metadata queries across the dimension. This ensures that a metadata query for one column adheres to security filters on other columns within the same dimension.
  NOTE: Metadata filtering on RLS does not respect Advanced hierarchies, such as Parent-Child Hierarchies (PCH), alternate hierarchies, and custom rollups.

• Semantic model process enhancements: Kyvos now brings the following semantic model process enhancements using the Kyvos compute cluster:

  • Resume failed or canceled semantic model process.

  • Run test data semantic model process job.

• Users can now use their existing Kubernetes cluster as shared cluster with Kyvos in Azure.
  NOTE: To use shared Kubernetes cluster, you must complete the required permissions.

• Kyvos now supports the following SQL Ranking and Analytical Window functions.

  • Ranking Window Functions: (ROW_NUMBER(), RANK(), DENSE_RANK(),PERCENT_RANK(), and NTILE() )

  • Analytical Window Functions: (CUME_DIST (), NTH_VALUE (), FIRST_VALUE (),LAST_VALUE() )

  • The Offset, Lag, and Lead SQL functions are also supported.

NOTE: The Window functions NTH_VALUE (), FIRST_VALUE (),LAST_VALUE(), and OFFSET will work only with Spark version 3.4.

Kyvos Reporting Service integration with Kyvos

With this release, Kyvos Reporting Services has been integrated with Kyvos. As a result of this integration, the Kyvos Reporting privilege is now automatically granted to Administrators. Additionally, Administrators have the ability to assign this privilege to custom roles. This privilege allows users to access the Kyvos Reporting option in the Toolbox. Upon selecting Kyvos Reporting, the Kyvos Reporting Dashboard will automatically log in and display options based on the roles and privileges assigned to the user. If the cluster is TLS/HTTPS enabled, signing out of the Kyvos application also signs you out of Kyvos Reporting.
NOTE: This offering can be deployed via Kyvos Manager on both on-premises and cloud environments.

Query Enhancement

Kyvos introduces a custom MDX function, RESPONSESUBSET, which limits the response considering the context of both axes.

Cloud Support Enhancements

Anchor
cloud cloud

This release comes with the following cloud enhancements:

• Query Engine Disk Scaling for Kyvos Enterprise: Kyvos now supports Query Engine disk scaling for Kyvos Enterprise (AWS, Azure, and GCP).

• Free Disk Space Check for Partition: Users can configure the free space requirement for all the required partitions. Disk partitions free space check is performed in cluster operations, such as cluster deployment, Kyvos upgrade, patch deployment, and rollback.
  NOTE: This is applicable to all cloud deployments (AWS, Azure, and GCP).

• Kyvos Reporting Service Node for Kyvos Enterprise: Users can now create, add, delete, or terminate the Kyvos Reporting Service Node on the Nodes and Services page in Kyvos Manager for Kyvos Enterprise on AWS, Azure, or GCP.

GCP Enhancements

This release comes with the following GCP enhancements:

• Automated deployment for Kyvos resources using Terraform scripts in GCP: Kyvos now supports automated deployment for Kyvos resources using Terraform script from GCP.
  NOTE: Deploying Kyvos resources using the Deployment Manager is still supported; however, Kyvos strongly recommends using the Terraform script from GCP for Kyvos resource deployment

• Kyvos Web Portal HA and Load Balancer creation: Kyvos now supports enabling Web Portal High Availability (HA) and creation of Load Balancer through Terraform script.

• Customer Managed Key (CMK) in GCP Terraform: For cloud storage, disk, and Secret Manager, users can now use Customer Managed Key (CMK) or Bring your Own Key (BYOK) while Kyvos resources deployment in GCP through Terraform script.

Kyvos Viz. Enhancements

Anchor
Kyvosviz. Kyvosviz.

This release comes with the following Kyvos Visualization enhancements:

• Filter Users and Groups for Entity Sharing: Users can now filter both the user list and group list in the access rights dialog box when sharing an entity with others.

• Common Filters and Parameters updated with the Same Value on the Target DashboardWorksheet: Users can not now update the common filters and parameters on the target dashboard worksheet with the same values selected on the source dashboard when an action is triggered. The destination filter can only be updated by the source filter if both filters are based on the same field and criteria.
  NOTE: To enable this feature, set the value of the overrideWorksheetFilterWithURLFilter property (present located in the portal.properties file) to True.

• Prefix Configuration for Small and Large Number Threshold in Charts: Users can now set the prefix for small and large number threshold for charts via the ‘prefixesOfSmallNumbers’ and 'prefixesOfBigNumbersForDataAndAxisLabel' property present in the portal.properties file.

• Enhanced Show Info Dialog Box: Users can now expand or collapse the sections of the Show Info dialog box in worksheets, chat sessions, and dashboards for better information management.

• Header or footer While Export Dashboard: Kyvos now supports adding a header or footer when exporting multiple pages. This feature provides options to customize the header or footer according to your needs.
  NOTE: Header or footer will not be available in the mobile view.

• Data label format: Users can now add data label formatting to XY family charts. When data labels are enabled, the format can be customized, allowing users to apply XY-specific smart data label formats tailored for these charts. By default, the data label format is set to ‘Smart.’ Alternatively, users can choose to set the data label format to ‘Default’, which is based on data format configured at the semantic model, dataset, or worksheet level.

API Enhancements

Anchor
API API

This release comes with the following APIAPIs:

• Get Workbook and Worksheet List: To fetch the list of workbooks and worksheets present inside the workbook from multiple folders.

  Endpoint: /rest/workbooks/workbooklist

For further details, please see the REST API guides.

JavaScript Events for Auto Save

...

• Deep Copy Semantic Model: To copy the semantic model to the required destination folder. It also creates a copy of the source entities of the semantic model and links them to the copied semantic model.

• Import Semantic Model Conversational Metadata: To import a conversational metadata file for a semantic model. It will update the semantic model metadata as specified in the provided file.

• Export Semantic Model Conversational Metadata: To retrieve conversational metadata for a given semantic model.
  NOTE: Conversational metadata includes descriptions, tags, and key element information for all elements of the semantic model.

JavaScript Events for Duplicating Card Widget

This release comes with the following JavaScript events:

• kyvos.viewer.db.onCardUpdateduplicateWidget: This event is triggered when the following operations are performed:

• Renaming the card title.  

• Updating properties from the Edit dialog box.  

• Renaming semantic model fields for the filter card.   

Updating the link card property for data card and filter card. 

API event requests Kyvos to duplicate widget card.

• kyvos.viewer.db.onDbLocalFilterCardFilterChangeonDuplicateWidget:This event is triggered when modifications are made to the non-shared filter card.kyvos.viewer.db.onCardRemove:This event is triggered when any card is deleted.
  NOTE: This JavaScript event was already present in previous versions.notifies the host application that the duplicate widget process has started. Initially, the widget shows a pending state. Once the process is complete, this event is triggered again to notify the host application that the duplicate widget process has finished.

New Properties

Anchor
newproperty newproperty

This release comes with the following new property:

• HELIXENABLE_PARTICIPANT_MAX_CONCURRENT_TASKS: To define the maximum number of tasks that can be executed concurrently on Helix participantKYVOS_REPORTING: To enable Kyvos Reporting Service on Kyvos.

...