Release Notes 6.5

Get ready to personalize your data analysis experience! The new release brings features for every user to set their own UI language and culture specifics with one click, introducing new grid KPI features and possibilities to enhance analytics and reporting, improved OLAP data source creation and management, and other useful improvements.

New Features and Improvements

  • Personalized Language Settings
    Previously, the user interface language was a fixed application-level setting, meaning all users shared the same UI language. With release 6.5, each user can now personally select their preferred UI language for the Kyubit BI web application. Kyubit administrators configure which languages, beyond the default, will be available for user selection in the web.config file. For example, if English is the default, but you want to allow users to select French, German, and Spanish, you would set:
    <add key="SessionLanguages" value="fr;de;es" />
    Of course, you can add any of the supported languages to be available for personal language settings (English en, German de, Spanish es, Portuguese pt, Dutch nl, Italian it, Russian ru, Norweigan no, Slovenian si, and Croatian hr).
    Once available languages are configured in the web.config file, users can navigate to 'User Settings' and click on their desired language/flag to select a different user interface language. The selected language will be applied immediately after saving user settings.
  • Personal Culture Settings
    Culture defines how numbers, dates, and times are formatted, including specific rules for decimal and thousands separators, as well as date display. Previously, the Kyubit application used a single, server-defined culture (from Windows Regional Settings) for all users. Now, with this release, each user can personally select their preferred culture to view numbers and dates in their desired format. Simply open 'User Settings' and choose from over 200 available cultures. Your new culture will be applied immediately after saving your settings.
  • Multitenancy Language and Culture Settings
    When running Kyubit in Multitenant mode, each tenant can be configured with its own specific user interface language and culture settings. The Master Administrator manages these tenant-level language and culture preferences within the tenant management form. Importantly, individual users can still set their personal language and culture settings, overriding those defined for the tenant. Kyubit administrators configure which languages, beyond the default, will be available for tenant/user selection in the web.config file. For example, if English is the default, but you want to allow users to select Dutch, Italian, and Portuguese, you would set:
    <add key="SessionLanguages" value="nl;it;pt" />
    You can add any of the supported languages to be available for personal language settings (English en, German de, Spanish es, Portuguese pt, Dutch nl, Italian it, Russian ru, Norweigan no, Slovenian si, and Croatian hr). Culture defines how numbers, dates, and times are formatted, including specific rules for decimal and thousands separators, as well as date display.
  • Grid KPI Custom Images
    Grid KPIs are crucial visual indicators that significantly enhance report and analytics readability, making it easier to spot important values. This release introduces the ability to upload your own custom images to represent specific KPI statuses. Image management is accessible from Administration > Images, or you can upload custom images directly when choosing an image for a KPI status. The image selection view will display both built-in and your uploaded custom images. To apply a custom image, navigate to the Grid KPI > Custom section, click on the default KPI image, and select your preferred alternative. Custom images are applied in the analysis, reports, dashboards, exported PDF files, and subscription content.
  • Grid KPI Scoring Type (KPI with 2, 3, 4, and 5 states)
    Previously, KPIs were limited to 3 states (Success, Even, Fail). Now, for KPI 'Scoring Type', you can choose from:
    2-states: Success, Fail
    3-states: Success, Even, Fail
    4-states: Success, Partial Success, Even, Fail
    5-states: Success, Partial Success, Even, Partial Fail, Fail
    Furthermore, you can customize each KPI state by selecting a distinct image, assigning a unique caption (visible on mouseover), and providing a more business-friendly name for the KPI state.
  • Grid KPI, the new Scoring Pattern 'Closer is Better'
    In addition to the previously available 'Higher is Better' and 'Lower is Better' scoring patterns, 'Closer is Better' is now available. This pattern evaluates values as successful when they are closer to a specified 'Target' value, and as failures when they are further away.
  • Grid KPI, Column Compare
    Resolve KPI status by comparing values across your columns. Your KPI will now evaluate the current value against the previous, next, first, or last column on the grid. For instance, quickly see if a specific month's performance was more successful than the prior month. You can also add an optional percentage tolerance to display an 'Even' KPI status.
  • Row Based KPI, Total column/row KPI and Grand Total KPI
    Expand your visual insights with new KPI display locations on the grid! In addition to the existing 'Grid KPI', 'Column KPI', and 'Cell KPI', you can now set a 'Row KPI', where the KPI definition applies to all values across the same row. We've also enabled KPI creation on Totals rows/columns. Furthermore, you can define a 'Cell KPI' specifically for the grand total cell on the grid, providing a visual indicator for overall performance.
  • OLAP Data Source Auto-Discovery
    Say goodbye to manual, tedious data source configuration. This new release simplifies connecting to your OLAP data by introducing automatic SSAS instance discovery. Instead of typing in every detail, Kyubit now instantly:
    1) Detects available SSAS instances.
    2) Lists all accessible OLAP/Tabular databases.
    3) Populates all available OLAP cubes and Tabular models within those databases.

    This automation is helpful for environments with numerous OLAP cubes or frequent data source configurations. It significantly reduces setup time, minimizes potential errors, and ensures a seamless, frustration-free experience for administrators and users alike, allowing them to focus on insights, not setup. Of course, you can still manually type in all details.
  • Analytic Model/OLAP Data Source Quick Search
    When starting a new analysis, typing in the search input automatically filters available OLAP and Analytic Model data sources, significantly speeding up your data source selection.
  • Analytic Models, Dimension and Detail Column Lengths
    Previously, Dimension and Detail values were limited to a fixed length of 255 characters, which was often insufficient for real-world data. Now, for any 'Dimension' or 'Detail' column in the analytic model, you can customize the length from 1 to 4000 characters, ensuring full data representation.
  • OLAP Cube Properties Display
    While in grid analysis, click the OLAP cube icon to display all properties for the OLAP cube/Tabular model directly from the SSAS instance. This includes key details like 'LAST_SCHEMA_UPDATE' time and 'LAST_DATA_UPDATE' time.
  • Single Date Filter for Multiple Analytic Models on the Dashboard
    Set up a single Dashboard date filter that will filter charts on the dashboard connected to various analytic models. A chart based on the analytic model now supports explicit filter connection. In this way, a chart will be refreshed with the date filter selection, even if the date field belongs to a different analytic model.