Quick Read
Continuing our commitment to offering the best BI speed and performance at any scale for all BI tools, Kyvos semantic layer brings many new and exciting features in the latest version – Kyvos 2022.3.
Kyvos empowers data scientists, BI specialists, data engineers, and business leaders to make better decisions with accurate and deeper insights into their business at the speed of their thought.
Our AI-powered smart aggregation technology and advanced features help enterprises perform multidimensional analytics on any cloud data platform, using any BI tool for sub-second insights on billions of data points. Let’s look at what’s new in the latest version:
Kyvos allowed calculated measures via MDX in its previous versions. Now, we make it better with an added capability to browse calculated measures in your BI tool while connecting to Kyvos via SQL as well. Users can leverage this capability to build calculations in their visualization tool and perform actions like filters and TopN without any barriers.
Since several BI tools allow connectivity only through SQL, this new update enables us to improve the versatility of our platform, no matter the connectivity interface you use. Your team can save time and resources by completing these actions within the Kyvos bundle instead of creating calculated measures separately on the BI tool.
The new Kyvos version enables you to define the scope of your data model in MDX through a manual script. It creates a sub-model where all individual queries can be run. The subsequent queries will run on that scope itself. With this functionality, you can design the sub-model and add, delete, or update the scripts on or over the data model . This can be done manually or through REST APIs.
Business queries are captured and operated from the production environment, while data modeling happens in the development cluster. To leverage the smart recommendations feature, users need to create data modeling improvements in separate clusters, causing an inability to create the right number and format of aggregates for faster query performance.
With the new release, the process becomes more user-friendly as you can now migrate queries from production to the dev environment leveraging the existing usage patterns to design an optimized data model.
You can also create multiple iterations based on accurate recommendations and design a strong aggregation strategy. It’s a smart way to identify the aggregates automatically to build the right data model size and deliver better response time.
Scalability and elasticity are at the crux of what we do. Kyvos lets you schedule your query engines per your usage patterns or control the capacity of query engines to save costs when you have lesser queries to run.
This additional new functionality allows you to configure the query engines and BI clusters based on the load. If there’s no query coming within a defined time, you can configure Kyvos to scale down the capacity and shut down the BI server and engine or reduce their capacity for a specific period when there’s no query traffic.
Use separate credentials on a single hive server to create multiple connections and control access to specific data. Users can now list or preview tables specific to the credentials designated to the source connection in the registered file. This way, users can access data related to their credentials only.
Leveraging the rising popularity of Entra ID for authentication and user management, we now support Entra ID integration for Kyvos deployed on AWS and GCP. This capability makes importing and syncing all users in this active directory easier without a glitch.
Kyvos now supports raw data querying on BigQuery for deeper insights. You can run queries even on summarized data as well as data filtered through ROLAP functions to drill down to the lowest granularity of information. The functionality will accelerate the speed of raw data querying.
Kyvos has introduced support for Tableau Online via SQL Connectivity to access any amount of data interactively on Tableau online with zero latencies in the latest release.
The update also includes a better TDS file connection for data model metadata. You can now export TDS files from Kyvos to SQL while retaining the metadata in the semantic layer. This way, the file will reflect the pre-defined formats in your Tableau worksheets.
When processing massive data volumes, we ensure faster speed with new enhancements in this release. For example, if you need to implement a change in a fact table, not in dimension data, you can now leverage our Fact Adjustment capability for incremental data refreshes. It will reduce the processing time to less than five minutes while controlling resource utilization and saving costs.
Kyvos strengthens web accessibility for all with a focus on increased inclusivity. In the new release, we’ve introduced many enhancements that will reiterate our commitment to better user experiences and complete compliance with WCAG 2.1 AAA Standards. It includes:
Kyvos smart aggregation is a query-based mechanism that allows users to filter and analyze any amount of historical data for materializing dimensions. Our smart recommendations engine helps build an aggregation strategy to get faster and deeper insights and add more aggregates to the existing ones.
With this new release, Kyvos has added more power to the smart aggregation feature. Now, Kyvos smart mode materializes additional dimensions as root dimensions when building a data model. This assures better query performance and speedier results for growing data volumes. Also, the system creates separate logs for recommendations to facilitate easy identification.
With every new release, Kyvos aims to revolutionize modern BI architectures with higher speed, improved performance, and accurate results. Version 2022.3 brings forth much-awaited updates that will resolve your everyday challenges when dealing with your business’s growing data and analytical needs.