Kyvos Excelerate (Excel Add-in)

Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

Kyvos Excel Add-in enables you to perform advanced analytics on extremely large datasets directly from Microsoft Excel. It helps you to create quick reports, drill-down to granular levels, and explore enterprise data limitlessly, all within Excel.

The Excel Add-in can connect to the Kyvos semantic models using the custom Kyvos connector (MDX Connectivity) and SQL connectivity (only for Extracts) for both Excel and Web Editions.

Some of the key benefits of using Kyvos Excelerate (Excel add-in) are:

1. Ability to search for members within a hierarchy, even when multiple members have the same name
   With the Kyvos Excel add-in, you can select multiple search cells to accurately retrieve the desired members from the grid designer. This feature provides more flexibility and precision when navigating and selecting specific members within the grid even if multiple members may have the same name.

2. Descendants Between feature
   Excel Add-in Web comes with a Descendants Between functionality. This feature allows you to easily retrieve a set of descendants between two specified levels or members within a hierarchy. You can specify the starting and ending points within a hierarchy, defining the desired range. The add-in then retrieves all the descendants falling between these two points, considering the hierarchical structure. This enables you to extract a specific subset of data that is located within a particular range of the hierarchy.
   Leveraging this feature, you can efficiently navigate through hierarchies, filter data based on specific ranges, and perform targeted analysis within the desired scope. This capability empowers you to focus on the relevant subset of data and gain valuable insights more effectively, streamlining their data exploration and decision-making processes.

3. Improved performance for range lookup and Formula Reporting
   The performance of range lookups on grids and formula-based reporting in the Kyvos Excel Add-in has been optimized to provide an enhanced user experience. With these improvements, range lookups, which involve searching for values within a specific range or criteria, are now faster and more efficient. By fine-tuning the performance specifically for these tasks, Kyvos ensures that you can access and analyze their data swiftly and accurately. Whether it's searching for values within a range, applying formulas to generate reports, or performing other related operations, the enhanced performance optimizes the overall user workflow and allows for seamless data analysis and reporting.

Supported versions

Getting started with Kyvos Excelerate (Excel Add-in)

To get started on Kyvos Excelerate (Excel Add-in), perform the following steps:

1. Download Kyvos Excel Add-in.

   1. Excel (Desktop) Edition

   2. Web Edition

2. Verify and ensure you have all the relevant prerequisites.

3. Install Kyvos Excelerate (FluenceXL)

   • Excel (Desktop) Edition: Double click the downloaded installation package to start the automated installation.

   • Web Edition

4. Activate Kyvos Excelerate Excel Add-in License

5. Create Kyvos connection for Excelerate Excel Add-in