Features and enhancements for 2024.2

Kyvos 2024.2 release brings the following enhancements and bug fixes.

Kyvos Reporting Service

With this release, Kyvos has integrated with Intellicus, allowing users to use the Kyvos Reporting Service offering. Kyvos Reporting Service is a comprehensive Business Intelligence (BI) suite that meets all the required BI requirements, such as importing data from various sources and generating reports quickly. This offering enables users to connect to Kyvos semantic models easily, simplifying the process of data analysis and report generation.

By integrating Kyvos with Intellicus for reporting service, users can benefit from a wide range of analytical features, including customizable options, predictive analytics, and real-time and mobile analytics, all of which can help facilitate decision-making.

NOTE: This offering can be deployed via Kyvos Manager on both on-premises and cloud environments.

Kyvos Modern Architecture with No-Spark Ingestion (Beta)

With this release, Kyvos has transitioned from using Hadoop clusters to employing Kyvos Analytical Store for semantic model processing. This enhancement has removed the dependency on Spark jobs for semantic model processing and building aggregates.

With the Kyvos Modern Architecture, users can process the semantic model using one of the following compute engines, which helps mitigate challenges:

• Query Engine (existing)

• Kubernetes (applicable only for new deployments)

The Kyvos Modern Architecture supports the following features with no Spark:

• Deploy Kyvos on all clouds (AWS, Azure, and GCP) without Spark: With this release, Kyvos has added support for no-Spark model processing to deploy Kyvos on all cloud environments through Query Engine or Kubernetes.
  NOTE:

  • For Azure and GCP, users can select a compute engine such as Kubernetes or Query Engine.

  • For AWS, users can only use the Query Engine as a compute engine.

• Support for no Spark and no Hadoop: The Kyvos 2024.2 release has supported no Spark and no Hadoop for on-premises Kyvos deployments.

• Support of MDX on ROLAP semantic models: With this release, Kyvos has added support for browsing the ROLAP semantic models using MDX and SQL.

• Azure SQL database connection without Spark: With this release, Kyvos has added support for creating an Azure SQL database connection to process semantic models using no Spark model processing.

• LOD queries on a single fact: With this release, Kyvos has added support for optimizing the level of detail (LOD) queries when they are querying on a single fact.

Query memory usage optimization

The Kyvos 2024.2 release has enhanced heap memory utilization for browsing semantic models processed using no Spark model processing.

Kyvos SaaS Portal on AWS for Cluster, User, and Subscription Management

With this release, Kyvos offers a Software-as-a-Service (SaaS) platform on Amazon Web Services (AWS). This new offering allows users to seamlessly orchestrate their clusters, customize subscription plans according to their needs, and efficiently manage user tasks in one place, saving time and effort. The application, designed with role-based access, allows for configuring user roles and permissions, managing subscription plans, and monitoring cluster performance and usage. Its user-friendly web interface provides easy access, with features customized to your specific roles and permissions.

Kyvos on Mobile Device

The Kyvos 2024.2 release enables users to access Kyvos on their mobile devices, offering business professionals the flexibility to stay connected and manage their tasks efficiently from anywhere.

SQL or MDX query execution without Kyvos Viz. or a third-party tool

With this release, Kyvos has introduced Query Playground. This new feature offers users and data designers a dedicated environment to write queries using popular languages like SQL and MDX. It allows interaction with semantic models and direct query execution without relying on the Kyvos visualization layer or third-party tools. This streamlines data extraction for downstream applications, semantic model validation, and query performance troubleshooting. Moreover, it enables users to export data in CSV and JSON formats.

Kyvos Analytical Store Enhancements

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

• Enhanced automatic BI Server and Query Engines' memory configuration: With this release, Kyvos has enhanced BI Server and Query Engine JVM configuration for the Auto mode.
  If the Kyvos Analytical Store is enabled and 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.

  • The BI Server’s Heap and Kyvos Analytical Store memory based on its total memory.

Support for passing a large list of filters in Kyvos via callback

With this release, Kyvos has added a query callback-based mechanism to efficiently apply filters to large cohort sets during query execution. This is achieved through a new function in the MDX query called CUSTOMKYVOSFILTER.

For further details, see Working with Large List of Filters in Kyvos.

Kyvos Excelerate enhancements

The Kyvos 2024.2 release supports FreeForm reports, allowing users to convert existing grids to Freeform reports.

Kyvos Manager Enhancements

• Support for Azure Active Directory (Active AD) for user management: This release has added comprehensive support for Azure Active Directory (Azure AD) in Kyvos Manager. With this enhancement, users can seamlessly integrate Kyvos Manager with Azure AD for robust authentication and user management.

• Audit logging to track all user and system actions: The Kyvos 2024.2 release has introduced a feature that allows users to access a detailed log displaying all user and system actions within the Kyvos Manager, located under Monitor > Audit Logs. This log captures activities, including logins, logouts, password modifications, and log downloads. Furthermore, users can now conveniently follow the sequence of events chronologically without switching between pages, capturing every action, from operations to basic activities such as logging in.
  NOTE: Users can download archived audit logs that are 30 days old. This release has also added support for modifying the duration of audit logs kept in the archive by modifying the AUDIT_LOG_RETENTION_PERIOD Kyvos Manager property.

• Kyvos Manager High Availability enhancements: The Kyvos 2024.2 release comes with the following enhancements to the Kyvos Manager High Availability:

  • Automating the addition and removal of Load Balancer entries for Kyvos Manager. This automation applies to the Marketplace (AWS and Azure) and AWS-managed service environments.
    NOTE: For the GCP Marketplace, if a Load Balancer was not created during deployment, Kyvos Manager will prompt for Load Balancer details if one has already been configured manually to facilitate further automation.

  • Downloading logs of passive Kyvos Manager.

• Process ID and uptime for Kyvos Manager services: This release supports displaying the Process ID and uptime for Kyvos Manager Services, regardless of whether Kyvos Manager HA is enabled.

• Support for loading more data: With this release, users can load more operations on the Operations and Audit Logs page by clicking the ‘Load More’ button.

• Support for loading user’s list: With this release, Kyvos has implemented the 'is in the list' or 'is not in the list' filter criteria on the Operations, Audit Logs, and Manage Subscriptions pages to get the user list. Initially, 500 users are displayed by default. To view additional users, click the 'Load More' button. You can also locate users quickly by using the 'Search' bar.

• Deploy managed Zookeeper on single or multiple nodes: With this release, users can deploy a managed Zookeeper cluster with single or multiple nodes post-deployment, especially when multiple BI nodes are present.

• Kyvos Manager User Interface (UI) changes: With the Kyvos Manager migration to VueJS, you will see changes in the Kyvos Manager UI at multiple places, such as fonts, text placements, etc.

  • The Audit Trails section has been moved to the Audit Logs section under Monitor and High Availability > Monitor. This enables separate tracking of configuration changes across different nodes.

  • For Kyvos Manager Dashboard UI changes, Process Details, and a new placement of the About section, see Components of Kyvos Manager Dashboard.

Performance Enhancements

• Session Set Query Enhancements: The Kyvos 2024.2 release has added support for pushing down MDX expressions, such as aggregate over set, where a scalar entity is not provided to Query Engines, enhancing query performance for session set queries. This support is extended to cases where measures from a single fact are present in the 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.

• Enhanced MDX query performance: The Kyvos 2024.2 release has improved MDX query performance when the ‘Filter’ function is used within Aggregate functions such as SUM, MIN, MAX, and PROD.

Security Enhancements

Upgraded Zookeeper version: In this release, Kyvos has upgraded Zookeeper to version 3.8.4 to address security vulnerabilities.
NOTE: Users needs to redeploy Zookeeper when they are upgrading from a previous release that uses an older Managed Zookeeper version to a Kyvos release that uses a newer Managed Zookeeper version. This is a one-time activity.

For further details, see Redeploying Zookeeper.

Cloud Support Enhancements

• Scaling Web Portal nodes for all paid Marketplace deployments (AWS, Azure, and GCP) and Managed Service: With this release, users can now effortlessly increase or decrease Web Portal nodes from Kyvos Manager for all paid Marketplace deployments and Managed Service.

• Enhanced load-based scaling: With this release, Kyvos has enhanced load-based scaling rules. These new rules will enable automatic scaling up or down of Query Engine instances based on their CPU and Memory usage.
  For further details, see Configuring Load-based scaling.

Azure Enhancements

• Kyvos deployment via Azure Template Specs: The Kyvos 2024.2 release has added support for deploying Kyvos on Azure using Template Specs. With this support, users no longer need to deploy Kyvos Manager for template generation to create Kyvos resources. This change simplifies the entire deployment process, making it more user-friendly.

• Support for generation 2 VMs: With this release, Kyvos has added support for generation 2 VMs for new deployments in adherence to security best practices.

• Automate system-assigned managed identity: With this release, Kyvos has automated the configuration of System-Assigned Managed Identity for new installations and upgrades. Users no longer need to manually configure the System-Assigned Managed Identity, as required in previous releases. However, to configure System-Assigned Managed Identity for other services, simply edit the value of the VM_IDENTITY property in the global.properties file from Kyvos Manager.

• Configure expiry date for secret keys in Azure via property: With this release, Kyvos has added support for setting an expiry date for secret keys in the Azure cloud environment. However, users can change the expiry date for the secret keys by modifying the SECRET_EXPIRY_TIME property in the 'global.properties' file on the Kyvos Manager.

AWS Enhancements

• Support for Graviton instances for RDS: The Kyvos 2024.2 release supports Graviton instances for RDS instance types (M6g and R6g).
  NOTE: This applies to AWS Enterprise.

• Support for Instance Metadata Service Version 2 (IMDSv2): The Kyvos 2024.2 release supports Instance Metadata Service Version 2 (IMDSv2) on AWS instances for new deployments.
  NOTE: This applies to all AWS deployments.

• ROLAP support with Databricks SQL warehouse: The Kyvos 2024.2 release supports Databricks SQL warehouse to execute ROLAP queries.

GCP Enhancements

• Scale BI Server and Query Engine nodes in GCP Marketplace: The Kyvos 2024.2 release allows users to scale BI Server and Query Engine nodes from Kyvos Manager on the ‘Node and Service Mapping’ page.

• Increase or decrease data disk of Query Engine nodes for GCP Marketplace deployments: With this release, users can now effortlessly increase or decrease data disk of Query Engine nodes from Kyvos Manager. Additionally, you can view data disk attached to the BI Server and Query Engine nodes.

Usability Enhancements

• Support for measure format in exporting semantic model metadata: The Kyvos 2024.2 release now supports exporting semantic model metadata in a TDS or PBIT file, including the Kyvos measure format. This format will be applied upon importing the file into Tableau or Power BI.

• Kyvos User Interface (UI) changes: The Kyvos 2024.2 release has made changes to the 'Home' page of the Kyvos Web Portal. This page now includes two tabs: 'Home' and 'Recent.' These tabs make it easy to navigate to the home page and access recently visited pages. For further information, refer to the Kyvos Web Interface section.

Kyvos Viz Enhancements

• Migration of Funnel and Packed Bubble charts from D3 to Amchart 5: With this release, the Funnel and Packed Bubble charts are migrated from the D3 library to Amchart 5.

• Bulk export of data cards from a dashboard: With this release, users can now export multiple data cards from the dashboard to CSV format.

• Share data cards from the dashboard via email: With this release, users can now share different data cards from the dashboard in CSV format via email.

• Schedule event-based email for worksheet and dashboard: Users can now schedule event-based email when data in the semantic model is updated or refreshed, including Full Refresh, Incremental Refresh, Test Refresh, or Drop Partition.

• Display parameter name in the ‘Show info’ dialog box: This release has added support for displaying the parameter filter in the ‘Show Info' dialog box if applied to a sheet or dashboard.

• Support for adding title to data card: With this release, users can assign a title to their data cards while editing a data card. The assigned title will appear, and you can also see the titles of all existing data cards along with their corresponding worksheets. This feature assists in identifying the details of a specific card created for a particular worksheet.

• Support for specific sorting orders for worksheet and dashboard filters: This release introduces specific sorting orders applicable to worksheet and Dashboard filters. You can now sort:

  • Dates: Choose 'Oldest on top' or 'Newest on top'.

  • Numerical values: Select 'Smallest on top' or 'Largest on top'.

  • Alphabetical order: Select 'A to Z' or 'Z to A'.

• Support for applying custom date filters: This release includes the option to apply a custom date filter to a worksheet.

• Support for hiding filter cards while exporting and emailing: This release has added support for hiding filter cards when exporting or emailing a dashboard or card.

• Support for adding non-data cards through JavaScript events: The Kyvos 2024.2 release has added support for adding non-data cards, such as Data cards, HTML cards, URL cards, Filter cards, and Group cards through JavaScript events.

• Support for selecting predefined date: With this release, users can now select a predefined date from the filter list for a single select criterion (is, is not, is after, is before, is before or equal to, is after or equal to, is between).

• Responsive dashboard to support mobile layout: With this release, Kyvos has introduced responsive dashboard configurations, enabling viewers to interact seamlessly with the dashboard across various layouts. Moreover, designers now have the flexibility to personalize their dashboards using tailored canvas settings, ensuring consistent layout integrity throughout all design phases.

  Furthermore, these dashboard features empower users to optimize visualizations for mobile devices and enhance overall accessibility and user experience. This flexibility extends to customizing specific dashboard properties to align perfectly with mobile layout design.

API Enhancements

This release comes with the following API enhancements:

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

• Enhanced API responses with the REST_API_COMPATIBILITY_VERSION property.
  NOTE: To view the changes in the REST API responses, the property’s value must be selected as 2.

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

For further details, please see the REST API guides.

New Properties

This release comes with the following new properties:

• The following new Kyvos Manager Properties have been added to the Kyvos 2024.2 release:

  • AUDIT_LOG_ARCHIVING_RETENTION_PERIOD: To provide the time interval (in days) after which the archived information will be purged from the Distributed File System (DFS).

  • AUDIT_LOG_RETENTION_PERIOD: To specify the time interval, measured in days, after which audit details will be purged from the repository.

  • REST_API_COMPATIBILITY_VERSION: To control the API Response format based on the specified value.

  • INTELLICUS_URL: To specify the Kyvos Reporting Service URL.

• chartWebAccessibilityMaxDataLimit (portal.properties file >Visualization properties for charts): To set the maximum data limit for disabling web accessibility on the Kyvos Web Portal.

• VM_IDENTITY: To define the managed identities associated with an Azure Virtual Machine and regulate Azure REST API calls from the Kyvos application.

• SECRET_EXPIRY_TIME: To configure the expiry date for secret keys in the Azure cloud environment.

Behavior Changes

Read more