Features and enhancements for 2024.2.x

Kyvos 2024.2.x 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.

...

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

Kyvos Modern Architecture

...

with No-Spark Ingestion (Beta)

Kyvos implements Hadoop clusters 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 Spark jobs. Each cloud provider offers its own Hadoop implementation (e.g., AWS, Azure, and GCP), leading to several challenges:

1. Complexity: Managing different vendor implementations is difficult.

2. Cost: Semantic model processing is expensive, and costs are borne by the cloud vendor.

3. Time: Analysis with Kyvos takes longer due to dependency on Hadoop cluster resources.

To address these issues, Kyvos has now transitioned from Hadoop clusters to native warehouse technologies for semantic model processing.

The following features are supported for Kyvos Modern Architecture without .

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 for on all cloud environments through Query Engine or Kubernetes.
  NOTE: Users can deploy Kyvos through Kubernetes and Query Engine for Azure and GCP. For AWS, Kyvos is deployed using no Spark model processing through Query Engine

  • 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 without 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 /wiki/spaces/KMS/pages/160107859 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 application supports setting access, allows for configuring user roles and permissions, managing subscription plans, and monitoring cluster performance and usage. The Its user-friendly web interface is easily accessibleprovides easy access, with functionality tailored features customized to your assigned specific roles and permissions.

Kyvos on Mobile Device

With this release, users can now The Kyvos 2024.2 release enables users to access Kyvos on their mobile devices. This enhancement allows business users , offering business professionals the flexibility to stay connected and manage their work more efficiently, no matter where they aretasks efficiently from anywhere.

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

With this release, Kyvos has introduced a new feature called the Query Playground. The feature provides a dedicated space for This new feature offers users and data designers a dedicated environment to write queries in a user-friendly environment, using widely used query languages such as using popular languages like SQL and MDX. They can interact with browsable It allows interaction with semantic models and execute queries directly direct query execution without relying on the Kyvos visualization layer or third-party tools. This simplifies extracting streamlines data extraction for downstream applications, validating data in a semantic model validation, or debugging and query performance troubleshooting. AdditionallyMoreover, it enables users can to export querying data in CSV and JSON formatformats.

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 are based on the total memory of the Query Engine machine.

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

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

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

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

Kyvos Excelerate enhancements

The Kyvos 2024.2 release now supports FreeForm reports, enabling 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: With this release, Kyvos has added support for accessing a comprehensive log that displays The Kyvos 2024.2 release has introduced a feature that allows users to access a detailed log displaying all user and system actions from within the Kyvos Manager, located under Monitor > Audit Logs. This includes activities such as log captures activities, including logins, logouts, password changesmodifications, and downloaded logslog downloads. AdditionallyFurthermore, users can now easily track conveniently follow the sequence of events without the need to navigate to different pages. All activities are recorded chronologically, irrespective of their category, whether an operation or a simple activity like 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 the 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 in a managed Zookeeper cluster 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 to pushdown of 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.

• Enhancements in 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 need needs to redeploy Zookeeper only when they upgrade 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 These new rules will allow you to automatically scale enable automatic scaling up or scale down the 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: In this release, Kyvos 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, simplifying . This change simplifies the entire deployment process and , making it more user-friendly.

• Support for generation 2 VMs: In 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 steps to configure the configuration of System-Assigned Managed Identity for fresh deployments new installations and upgrades. Users no longer need to perform additional manual steps as required in earlier releases to configure 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 sets the expiration has added support for setting an expiry date for secret keys in the Azure cloud environment. However, users can modify change the expiry date for the secret keys by using modifying the SECRET_EXPIRY_TIME under  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 fresh 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: With this release, : The Kyvos 2024.2 release now supports exporting semantic model metadata in a TDS or PBIT file will include , including the Kyvos measure format. This format will be applied when upon importing the file is imported into Tableau or Power BI.

• Kyvos User Interface (UI) changes:  This The Kyvos 2024.2 release has modified the ‘Home’ made changes to the 'Home' page of the Kyvos Web Portal. This page features now includes two tabs, : 'Home' and 'Recent,' facilitating easy navigation .' These tabs make it easy to navigate to the home page and access recently accessed visited pages as required. 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: Opt for 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 eventevents: The Kyvos 2024.2 release has added support to add for adding non-data cards, such as Data cardcards, HTML cardcards, URL cardcards, Filter cardcards, and Group Card cards through JavaScript eventevents.

• 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:

...

• Enhanced API responses with the REST_API_COMPATIBILITY_VERSIONproperty.
  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 Propertieshave 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 regulates 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

...