Features and enhancements for 2023.3

Kyvos 2023.3 release brings minor bug fixes and the following enhancement.

Announcing Kyvos Free on Azure Marketplace

This release introduces the Kyvos Free (also known as Kyvos SNS), which is now available on Azure Marketplace. The Kyvos Free is a free account that provides access to Kyvos' innovative and powerful features without any license cost or contractual obligations. This setup is perfect for customers who want to use Kyvos for small data or have limited resources. The Kyvos SNS setup is streamlined and hassle-free, requiring minimal resources and permissions. In this setup, all Kyvos resources are installed on a single node, simplifying the setup and monitoring of Kyvos services. With efficient resource allocation and utilization, customers can maximize the potential of their existing infrastructure.

Kyvos Free on GCP Marketplace

This release introduces the Kyvos Free, which is now available on GCP Marketplace. The Kyvos Free offering is a free account that provides access to Kyvos' innovative and powerful features without any license cost or contractual obligations. This setup is perfect for customers who want to use Kyvos for small data or have limited resources. The Kyvos Free setup is streamlined and hassle-free, requiring minimal resources and permissions. In this setup, all Kyvos resources are installed on a single node, simplifying the setup and monitoring of Kyvos services. With efficient resource allocation and utilization, customers can maximize the potential of their existing infrastructure.

Redirect to custom page in case of external SSO failure for Kyvos web portal

The Kyvos 2023.3 release comes with enhancements to the Kyvos basic authentication. Administrators can now disable the login form for native user credentials and redirect all login requests to external SSO authentication, in case there is a failure in authentication for the Kyvos Web portal.

Backup logs on the persistent store for all Kyvos services

This release includes an enhancement allowing users to back up Kyvos Web Portal and Kyvos Manager logs on a persistent store using the LOG_ARCHIVE_DAYS property from the global.properties file.

Export Kyvos Manager operations logs

This release has included support for exporting all logs related to various operations or actions performed within Kyvos Manager and downloading the required logs in CSV format.

Support for sharing feedback or reporting an issue

At Kyvos, we firmly believe feedback is crucial for continuous improvement. It not only benefits our customers by providing a means to voice concerns or ideas but also aids us in enhancing our offerings, resolving issues, and fostering better communication and understanding between us and our valued customers.

With this release, Kyvos provides the ability to share your feedback regarding your experience with the product from the web portal. We encourage you to share your suggestions and experiences regarding our products by submitting your valuable feedback.

Create custom parameters for worksheets and dashboards

With the Kyvos 2023.3 release, users can create custom parameters using numbers, characters, or dates as placeholders for values. These placeholders can be dynamically changed within the worksheet for filters, highlight conditions, cohort filters, and calculated measures. Furthermore, custom parameters are accessible across all worksheets and dashboards within the workbook.

Add tags to processing jobs for easy identification

With the Kyvos 2023.3 release, you can now add tags to your data processing jobs while they are being executed. By assigning relevant tags to each job instance, you can better organize your workflow, making it easier to filter and sort through all the different job instances. This tagging feature will make it simpler to manage your jobs and locate and distinguish between various job instances.

Kyvos ODBC Driver with Kerberos authentication

Kyvos ODBC Driver now supports Kerberos authentication on Windows. Furthermore, users can specify the number of rows fetched per chunk on all platforms.

NOTE: The Tableau Kyvos connector has been upgraded with Kerberos support.

Browse calculated measures created on HOLAP semantic model

User can now browse calculated measures created on HOLAP semantic models in Power BI through SQL connection. To ensure successful query execution, it is important to include materialized fields when using the view, filter, calculated measure, or non-empty behavior. Please note that the query will fail if non-materialized fields are used in the view, filter, calculated measure, or non-empty behavior.

NOTE: 

• To enable calculated measures in the HOLAP semantic model, the value of the kyvos.query.holap.calculated.measures.enabled property must be set to true.

• Do not change any field to non-materialized after the semantic model is processed. 

Sort field support for third-party BI tools

From Kyvos 2023.3 onwards, when you apply sorting to a column having a sort field, Kyvos will sort the default visualization of that level or attribute based on this sort field. This applies to Kyvos Viz and third-party BI tools except MicroStrategy.
NOTE: The sort field will be applied to all types of hierarchies, including normal hierarchy, time-type hierarchy, parent-child hierarchy, multiple hierarchies, alternate paths, custom rollup dimensions, and more.

Enhanced embedded analytics

Kyvos web application can integrate into your enterprise application for a seamless user experience. This release comes with enhanced JS events and APIs to further improve the embedded analytics experience for users.

Performance enhancements

 Improved performance for semantic models having alternate hierarchies with flattened data patterns

The Kyvos 2023.3 release comes with enhanced query performance for semantic models having alternate hierarchies, with increased materialization. Kyvos can pre-aggregate values of Alternate paths with flat data in Expert mode. As a result, queries will be served with pre-aggregated results, resulting in optimal query performance.

The increased materialization may result in larger semantic model process size (depending upon number of shared members and total alternate hierarchies present in semantic model).

Kyvos Manager enhancements

• Configure Kyvos Manager properties via Kyvos Manager: Users can now set advanced properties from the Kyvos Manager Properties page, previously managed in the /kyvosmanager/conf/kyvosmanager.properties file, to fine-tune performance or extend Kyvos Manager functionality.

• Enhanced Kyvos Manager Tomcat Server log management: With the Kyvos 2023.3 release, all Tomcat Server logs will be generated at /kyvosmanager_war/kyvosmanagerdata/server/tomcatLogs/ location. The logs will continue to be generated at the same location, ensuring consistency in log management, even after upgrading Kyvos Manager.

• Enhanced email notifications: The Kyvos 2023.3 release introduces the ability to select a single user for email notification and select single Node Usage and Services notification as per business requirement. This allows the users to manage notifications according to their specific needs, rather than selecting  all notifications.

• Automatic deletion of Kyvos backup bundles: With this release, Kyvos now supports automatic deletion of backup bundles that are created during the upgrade and patch processes. The system automatically deletes the oldest backup bundle to ensure that only the newest bundles are retained within the specified limit set by the user. The default limit is 5, but users can adjust it as needed.

• Kyvos Manager interface 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, and so on.

Cloud support enhancements

Reduced bootup duration for Query Engine

The Kyvos 2023.3 release comes with optimized Query Engine boot-up time by selectively downloading the necessary bundles as they are needed. Additionally, this release comes with enhancements to reduce the initialization time of the Query Engines.

Balance credits estimation support

With the Kyvos 2023.3 release, users can see an estimate of the remaining days before your credits are depleted, based on historical usage data. With this enhancement, users can easily estimate the days remaining before your credits are depleted directly from the dashboard. This added visibility ensures better control over your credit usage and enables you to plan your credits consumption accordingly. 

Azure enhancements

• Deploy Kyvos using an existing virtual network: The Kyvos 2023.3 release on Azure Marketplace now allows for deployment using an existing virtual network.

• Enhancements in Kyvos Cluster deployment with Application Gateway: With the Kyvos 2023.3 release, if Web Portal high availability is enabled, or if a non-peered network exists between Kyvos and Databricks, the Kyvos cluster will be deployed with a Application Gateway. 

• Add or delete Query Engine nodes for Kyvos Azure Marketplace deployments: Users can now easily create or delete Query Engine nodes directly from the Kyvos Manager on the Node and Services > Overview page, ensuring quick increase or decrease to the Query Engine nodes without the need to create Virtual Machines. 

Kyvos Viz enhancements

• Reference band or line in Kyvos XY charts: This release allows users to create bands or lines on Kyvos XY family charts. These can be horizontal or vertical reference markers used to compare data to specific values. Additionally, these reference lines or bands will be included when the chart is saved in PDF format.

• Setting line width and style: Users can now specify the line width and line style for XY (Line, Area, and Curve charts) family charts in the Kyvos worksheet. 

• Manual scaling: With the Kyvos 2023.3 release, users have the ability to manually adjust the scaling of all XY type charts, such as Bar, Column, and Line charts. This feature allows for customization of the value axis scale to best fit the user's needs, resulting in an optimal viewing experience for their data. 

• Format measures in worksheets This release provides various default number formats such as numbers, currency, percentage, scientific, and custom at a worksheet level. Previously, users had to access the semantic model to change the format. Users can now change the number format, such as reporting in millions or percentages, or adjusting decimal places. Additionally, the decimal places or date format for measure can be altered across multiple reports.

• Format date attributes in worksheets: This release introduces the ability to generate reports with your preferred date format by formatting date attributes within the worksheet. Previously, users had to access the semantic model to change the format. Users now have the flexibility to select from pre-defined date formats or create their own custom date format.

Usability enhancements

• View Web Server logs on Monitor: With this release, users can now view Kyvos Web Server logs on the Monitor's page of the Kyvos Web Portal. 

• Adjust height of BI Servers and Query Engines panels: With this release, users can adjust the height of the BI Server and Query Engine panels on Kyvos Web Portal's Monitor page while monitoring them.

• Export semantic model metadata: This release includes a utility that enables users to export semantic model metadata for Power BI, which is identical to Kyvos Semantic model. 

• Progress bar for Update Aggregates: With this release, triggering an Update Aggregate process will display a progress bar showing the status of the processed cuboids, elapsed time, and the percentage of processed cuboids on the Job Summary page. This progress bar simplifies the process of monitoring processed cuboids and ensuring seamless operations.

• Cancel the Drop Partition jobs: This release introduces the ability to cancel the drop partition jobs. 

API enhancements

REST APIs 

The Kyvos 2023.3 release comes with support for Kyvos and Kyvos Manager REST APIs. The REST APIs are intended to deploy and manage the Kyvos cluster via automation and reduce manual efforts.

Rest APIs added for the Kyvos 2023.3 release are:

Kyvos REST APIs 

• For workbooks and worksheets 

  • Rename Worksheet

  • Copy Worksheet

  • Move Worksheet

  • Rename Workbook

  • Update Semantic Model of Workbook

  • Get Parameters of Workbook

  • Delete Parameters of Workbook

  • Add Parameters in Workbook

• For datasets

  • Rename Dataset

• For dataset relationships

  • Rename Dataset Relationship

• For semantic models

  • Rename semantic models

• Import export utilities

  • Import CAB

  • Export CAB

Kyvos Manager REST APIs 

• REST end point for patch 

  • Apply Patch for Kyvos  

  • Patch Version Listing

• REST end points for rollback

  • Rollback Bundle Listing

  • Rollback Application

• REST end point to start, stop and restart Kyvos services  

  • Start/Stop/Restart Cluster Services

  • Start/Stop/Restart Specific Service

  • Start/Stop/Restart Given Node Services

  • Start/Stop/Restart Given Services on Node

REST APIs for semantic model query Analyzer 

To enhance Postgres performance in handling loads, the following REST APIs have been added for truncating and deleting query analyzer tables that contain data huge amount of data: 

• TRUNCATE: Used for deleting data from a single table or multiple tables. 

• DELETE: Used for deleting data based on the number of days, for a specific date or time, or for a specific user. 

New Properties

This release comes with the following new properties:

• allowSMExportForPBI (portal.properties file): Enables or disables exporting the semantic layer view of the Kyvos semantic model for Power BI, which can be used when connecting using the Spark SQL connector.

• kyvos.query.holap.calculated.measures.enabled: Enables or disables calculated measures support in the HOLAP semantic model on Power BI. 

Behavior changes

Non-empty behavior for calculated measures

The release has introduced modifications to the Non-empty Behavior for calculated measures. The updated Non-empty behavior will now function as follows:

• By Expression: In this case, a calculated measure's value will be considered null if the evaluation of the expression for that calculated measure is null.

• By Measures: Here, a calculated measure's value will be considered null if all the selected measures are null across a tuple.

• By Measures, Then Expression: In this scenario, a calculated measure will be considered null if both the selected measures and the value of the expression are null.

Support for CDP version 7.1.8

With the 2023.3 Release onwards, Kyvos supports only the latest CDP version 7.1.8. Before upgrading to Kyvos 2023.3, you must upgrade to CDP version 7.1.8. If you want to proceed with a lower version of CDP (below 7.1.8), contact Kyvos Support for compatible release certification.

Read more