...
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 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: UsersFor Azure and GCP, users can deploy Kyvos through Kubernetes and Query Engine
.
For AWS,
users can deploy Kyvos through Query 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.
...
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 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 . Additionally, users can export querying troubleshooting. Moreover, it enables users to export data in CSV and JSON formatformats.
Kyvos Analytical Store Enhancements
...
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.
...
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 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.
...
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.
...
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.
...
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.
...
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 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.
...
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.
...
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 '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.
...
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.
...