3.3.119

Cloud Analytics Server
Released on May 26, 2021

New Features

Widgets

  • Now, you can show pivot values in Row axis.
  • Now, you can customize the legend position of Accumulation charts.
  • Now, we can scroll and see the last data of chart using single scroll.

Data Sources

  • Handled Xero connector API limitation to call only 60 APIs in single minute.

Improvements

Widgets

  • #I327297 – The bug fixed in chart drilldown using axis labels.
  • #324754 – The bug fixed in Text widget for label parameters.
  • Grid virtual scroll performance has improvement for Fit to Content enabled case.
  • The bug fixed in Pivot Grid linking when set the values fields display as row axis.

Designer

  • #309889 – Now, the size of the image files configured on the widgets can compressed while designing, which results in effective performance on the dashboard rendering.
  • #325723 – The bug fixed for the search option in the multi-selection combo box.
  • #322638 – The bug fixed for the filter value retain in the filter overview.
  • #309889 – Now, the dashboard layout will be smooth on initial rendering instead of waiting for a while.
  • #320229 – Fixed issue in exporting dashboard as Image/PDF.
  • #326987 – The bug fixed to display widget comment option even though we disabled the comment in dashboard level.
  • #327783 – The bug fixed for dashboard parameter is not working when using in URL.
  • #323026 – The bug fixed in relative type dashboard parameter when using it in stored procedure.

Data Sources

  • #323373 – Provided max rows option in SQL data sources to extract the limited rows of data.
  • The bug fixed in the Microsoft SQL Server data extraction.
  • The bug fixed in the PostgreSQL filter, if the data contains Slash(‘\’)
  • Fixed unclosed connection in PostgreSQL and SQL server.
  • The bug fixed in the Google Big Query shared data dashboards.
  • #327002 – The bug fixed in the unnecessary decimal digits appending while using concat expression.
  • Fixed Object reference issue in Code view mode.
Note : The bug or feature items that do not have a corresponding ID associated with them are internally identified.

3.3.113

Cloud Analytics Server
Released on Apr 30, 2021

New Features

Widgets

  • Now, you can view non-aggregated data in charts and range navigator.

Improvements

Designer

  • #321569 – The chart widget issue in schedule exporting has been fixed.
  • #318904 – The display of an unwanted loading indicator issue when closing the dimension filter window has been fixed.
  • #319253 – The duplicated data showing issue in the allow filtering dialog on search has been fixed.
  • #319222 – The issue in a switch from code to design view has been fixed.
  • #318831 – The issue in initial selection when loading from the draft has been fixed.
  • #320045 – The issue in “URL filter when using the dashboard parameter” has been fixed.
  • #320977 – The issue in “Dashboard parameter when using URL filters” has been fixed.
  • #321751 – The issue in “Advanced color formatting window for the SSAS connection” has been fixed.
  • #320978 – The issue in “Pie chart drill-down when configured filter section” has been fixed.
  • #321101 – The issue in “data preview UI” has been fixed.
  • #323026 – The issue in “Data type dashboard parameter usage in the stored procedure” has been fixed.
  • The console error is fixed when opening the data alert window.
  • The issue in “The selected condition state maintenance in the data alert window” has been fixed.
  • Restricted to display filter widgets in data alert window.

Widgets

  • #319902 – The axis label cropping issue in charts has been fixed.
  • #318349 – The legend scroll bar display issue in charts has been fixed.
  • #315894 – The duplicate color palette pop-up display issue in the advanced color formatting window has been fixed.
  • When opening a draft/saved dashboard in design mode, an unwanted auto-recovery alert is no longer displayed.
  • The bug in “Data label display for drilled chart even if it is disabled from the property panel” has been fixed.
  • The bug in “Axis label formatting button display in charts whenever the axis title is disabled” has been fixed.

Data Sources

  • #320323 – A bug in “The forecasting feature when the data contains a null value” has been fixed.
  • #318939 – The bug in “The MySQL date user filter” has been fixed.
  • #322265, #322262, #322262 – Improvised Azure DevOps connector by handling pagination and endpoint selection.
  • #324149 – In File selection explorer, the scrollbar issue for the Smartsheet connector has been fixed.
  • #323523 – MongoDB connector improvised to handle date time datatype, as well as automatic detection of a primary cluster to connect.
  • #324314 – Fixed Smartsheet connection issue by handling empty cells.
  • #325334 – The refresh issue with the OneDrive data source has been fixed.
  • #324080, #322263, #325896 – The refresh issue with the Azure DevOps data source has been fixed.
  • The bug in “PostgreSQL DATEADD and DATESUB expressions while assigning values in the grid widget has been fixed.

Server

  • Performance improvement in the multi-tab dashboard.
  • #320035 – The issue in “Getting the user details using API when the user email contains the + symbol” has been fixed.
  • #324786 – An issue in “Updating the cloned dashboard when the original dashboard was deleted” has been fixed.
Note : The bug or feature items that do not have a corresponding ID associated with them are internally identified.

3.3.106

Cloud Analytics Server
Released on Apr 05, 2021

New Features

Widgets

  • #314756 – Now, you can customize the font size of the following elements in the chart:
    • Axis labels and title
    • Data label
    • Legend title and items
  • Now, you can customize the font size of the following elements in Pivot Grid:
    • Headers
    • Content
  • #318349 – Now, you can change the Value Label Position of Cartesian Charts as follows:
    • Top
    • Middle
    • Bottom

Improvements

Designer

  • #316567 – Now, the label parameter configured from the dynamic parameter can respond with on-demand parameter value change.
  • #311806 – Now, you can embed the dashboard in design mode with an updated version of jsrender (1.0.5 or greater).
  • #315894 – Resolved the issues with dashboard embedding, now the dashboard instance will not conflict between two instances.
  • #315894 – Now, the color palette on advance mode color customization is positioned well, while embedding the dashboard with your application.
  • #315894 – Now, the preview and publish button on design mode will show even with minimum screen resolution.
  • #320082 – The issue with “date range display text” has been fixed.
  • The issue with “when passing null value as a filter from the user-based filter” has been fixed.
  • The issue with “when showing unhide columns in a hidden state, after editing the data source” has been fixed.
  • The issue has been fixed for the RTE widget in schedule exporting.

Widgets

  • #317906 – Tree Map widget no longer creates color inconsistency issue between design mode and view mode.
  • Tree Map widget rendering performance has improved for the large dataset by setting top 100 records filters by default.

Data Sources

  • #317197 – Improved data refresh in Google Analytics connector to fetch future data without setting end date.
  • Provided support to access specific schema from PostgreSQL by entering schema name in additional parameter field in the connection dialog box.
  • Provided support for UUID data type in PostgreSQL.

Server

  • #320294 – Fixed the issue in listing categories, while creating the multi-tab dashboard.
Note : The bug or feature items that do not have a corresponding ID associated with them are internally identified.

3.3.103

Cloud Analytics Server
Released on Mar 18, 2021

New Features

Designer

  • #313781, #313867, #303953 – Dedicated filter section for widgets: You can now use any fields in the data source to apply the filter for widgets.
  • #315894 – Added ‘hidePopup’ method on Bold BI instance for disabling the waiting pop-up manually, while embedding dashboard in design mode.

Widgets

  • #315330 – Now, Bing map supports image and PDF exporting.

Data Sources

  • #316400 – Added new Nutshell connector support.
  • #310878 – Added new Fitbit connector support.
  • #319132 – Added new Square Up connector support.

Server

  • Exposed an API to get draft dashboards.

Improvements

Designer

  • #314719 – The bug fixed in data source read and write permission.
  • The bug fixed in the dashboard using the combine data source.
  • The bug fixed for bind parameters in combo-box.
  • The bug fixed in export and view underlying data when using the dashboard parameter in filter widgets.
  • #316376, #313354 – The bug fixed in dashboard rendering in mobile app.
  • #315894 – The bug fixed in preview and publish button, disappear in embed application.
  • #313838 – Improved ‘beforeNavigateUrlLinking’ event with widget level arguments as ‘widgetName’ and ‘widgetId’ for widget wise customization on URL linking option.

Widgets

  • Radial Gauge widget’s Property Panel section names, such as “Minimum” and “Maximum” are now renamed as “Minimum Value” and “Maximum Value”, respectively.
  • Radar Polar chart no longer has a color palette inconsistency issue between designer mode and view mode.
  • The bug fixed in chart breadcrumb label colors in dark theme.
  • #318520 – Alignment issue with clear filter icon in grid allow filtering has been resolved.

Data Sources

  • #311210 – The bug fixed in the code view data refresh for SQL data source extraction.
  • #312954 – The bug fixed in the MySQL live mode connection table schema fetching.
  • #315326 – The bug fixed in Azure DevOps connection by removing unwanted scopes.
  • #311210 – The bug fixed in the data refresh for SQL data source extraction.
  • #316318 – The new refresh token was handled for QuickBooks Online data source to avoid account expiration issue.
  • #316255 – The bug fixed in Azure template dashboard for connecting with live account.
  • #317663 – Dropbox refresh token was handled for short lived token.
  • The bug fixed in the to_char() expression for PostgreSQL data source.
  • The bug fixed in the integer to date converted columns for PostgreSQL data source.

Server

  • Fixed an issue in creating a schedule with a date format – DD MMM YYYY.
Note : The bug or feature items that do not have a corresponding ID associated with them are internally identified.

3.3.97

Cloud Analytics Server
Released on Feb 11, 2021

Improvements

Designer

  • #311711 – Dashboard parameter can now be configured with combo box filter widget, within a dashboard.

Widgets

  • #312691 – Text widget no longer shows data retrieval error, while switching tabs between preview and design mode.
  • Chart widget no longer shows data retrieval error while binding records in x-axis.
  • Now, grid widget will show row selection effects while performing row-based linking.
  • Radial Gauge widget’s Assign Data section names, such as “Start Value” and “End Value” are now renamed as “Minimum Value” and “Maximum Value”, respectively.

Data Sources

  • Facebook data source API version is now upgraded from 7.0 to 9.0.
  • Problem in connecting some specific APIs in Recurly data source have been now resolved.
  • #297231 – Deprecated column name changes for Jira data source has been done.
  • #297231 – The Jira connection with large data is now working as expected. Initially, 1000 records will be loaded and rest of data will get updated in next data refresh.
  • #313354 – Asana data source token expiration is now handled properly to extract large data in normal and iterative mode.
  • #311210 – SQL data source extraction with incremental update is now working as expected.
  • #313358 – Iterative extract mode data source with large data is now handled properly with background retries for failed API calls.
Note : The bug or feature items that do not have a corresponding ID associated with them are internally identified.

3.3.94

Cloud Analytics Server
Released on Jan 28, 2021

Improvements

Designer

  • #309231 – Cleared initial selection filters in the widgets is no longer maintained in saved dashboards’ views now.

Widgets

  • #309681 – Series color palette now works as expected in stacked charts.
  • #311609 – Date picker widget no longer throws browser console errors when reloading the dashboard page with null data.
  • Grid widget no longer throws browser console error when setting grid as a master widget without configuring the data.

Data Sources

  • #311210 – The data refresh of SQL data source extraction with large number of rows now works as expected.

Server

  • #311742 – Widgets with special characters in its name can be now pinned from the dashboard.
Note : The bug or feature items that do not have a corresponding ID associated with them are internally identified.

3.3.92

Cloud Analytics Server
Released on Jan 21, 2021

Improvements

Designer

  • Data source query designer no longer throws browser console error when same table is dropped several times.
  • Columns search works as expected now when applying a data source level filter.
  • #304664 – Improved the error handling in OAuth redirection request when the cached token is expired.
  • #309889 – Improved the performance of dashboard rendering when it is scrollable with more widgets.

Data Sources

  • #310773 – The Week Year date format is now shown properly in widgets.
  • #311210 – SQL Server data extraction, now works as expected when data length is greater than the data type length.
  • TO_CHAR() expression now works as expected in PostgreSQL data source.
  • Help documentation link is updated for the SQL Server stored procedure in the OPENQUERY option.
  • #311188 – GitHub template dashboard no longer throws exception when deployed.
  • The widgets’ values from the sample data are now updated in the ServiceNow template dashboard.

Server

  • Data source’s refresh settings no longer throws exception, when configuring the settings after triggering it manually.
Note : The bug or feature items that do not have a corresponding ID associated with them are internally identified.

3.3.91

Cloud Analytics Server
Released on Jan 19, 2021

Improvements

Designer

  • Improved color palettes in template dashboards.

Widgets

  • #310601 – The bug fixed in maintaining maximize icon’s visibility in the card widget.
  • #310601 – The bug fixed in displaying legends, when binding a field in row section in the chart widget.

Data Sources

  • #304622 – The bug fixed in Oracle stored procedure, in value types of parameter.
  • The bug fixed in preview table selection, in Asana and SurveyMonkey data sources.
Note : The bug or feature items that do not have a corresponding ID associated with them are internally identified.

3.3.88

Windows
Released on Jan 5, 2021

New Features

  • Provided support to pass the filters along with the access token securely.
  • Provided support to embed the multi-tab dashboards.

Important Note

  • You need to use the updated embed JS version, hosted in CDN.

Designer

  • Custom attributes in dynamic connection string: You can use custom attributes to dynamically change the connection string for SQL live mode data sources.
  • Dedicated filter section for widgets: You can now use any fields in the data source to apply the filter for widgets.
  • Widget background customization: You can now change the color or set an image as background for widgets.
  • Font customization support: You can now customize the font of dashboard title, widget title, and widget subtitle from the property panel in the designer.
  • You can customize the overall dashboard font styles such as weight, size, and font family using the JSON settings.

Widgets

  • Provided support to bind dimension fields in tooltips.
  • Provided choropleth and drill-down support in Bing map.
  • Provided drill-down support in heat map.
  • Provided an option to change the foreground and background color of grid rows and alternate rows.
  • Provided an option for column resize and fit to content in pivot grid.
  • Provided an option to load marker using postal code or addresses in Bing map.
  • Provided an option to set background color or background image for widgets.
  • Provided an option to change the font color in all cartesian charts, heat map, map, range navigator, and range slider.
  • Provided support to show both bar and line type series at the same time in combo chart.
  • Provided support to view the underlying data and performing URL linking operation in Bing map.
  • Provided an option to change grid header and value font size.
  • Provided an option to define number of rows and columns for series cards.
  • Provided an option to swap, measure and title position in number card.
  • Provided an option to change the alignment of number card value.
  • Provided responsive font size support for card widgets.
  • Provided an option to set defined width for each column in the grid.
  • Provided support to format primary and secondary axis labels in the charts.
  • Provided an option to display pivot value fields in row axis.
  • Provided support to customize font settings of widget elements from the theme file.
  • Provided filter interaction support in custom widgets.

Data Sources

    • Now, you can connect and create dashboards by using the following new data sources:
      • Elasticsearch
      • Amazon Athena
      • Spark SQL
      • Azure DevOps
    • Stored procedure is now supported for Oracle data source.
    • Expression: Added support for total Percentage expression in all SQL data sources.

Server

  • Custom attribute REST API: You can add, update, and delete custom attributes for users, groups, and sites using the REST API.
  • Isolation code using the configuration file: You can configure the isolation code and custom attribute in the configuration file to achieve the complete isolation support for sharing multi-tenant embedding solutions.
  • UI customization using the configuration file: You can use the configuration file to create your own custom menus. Also, you can hide or rearrange the existing menus.
  • Support for MySQL: Now, Bold BI application can be setup using MySQL as meta-database.
  • Azure app service deployment: Now, Bold BI can be deployed on Azure app service using the ARM template.
  • Draft data source: Now, you can continue editing the unsaved draft data source from the data source listing page.
  • Provided support for global embed secret that can be used for multi-tenant authentication.

Improvements

Designer

  • Provided support to resize the widget configuration sections in the property panel.
  • Performance improves in the dashboard rendering.
  • Provided support to preview the dynamic connection string configuration in the designer preview.
  • Fixed the bug where dashboard parameters used in custom query throw exception.
  • Fixed the bug when using the dashboard parameters in the stored procedure.

Widgets

  • Provided support to display description icon for single card.
  • Provided Trim option for axis labels in the chart.
  • Provided an option to show or hide value labels for each series.
  • Improved multi-selection behavior in Combo Box.
  • Provided grid row height adjustments support for grid header.
  • Provided an option to change the grid data bar color.
  • Provided an option to show or hide grid header and grid border.
  • Provide support to set the initial zoom position of Bing map.

Data Sources

  • Provided support for materialized views in PostgreSQL.
  • Provided support for date sorting in SQL Server Analysis Service data source.
  • Fixed Connection Pool exhausted issue in PostgreSQL intermediate database to exact data sources.
  • Fixed Top N issues in MemSQL data source.
  • Fixed date picker conversion column issue.
  • Fixed POP widget issue for all SQL data sources.
Note : The bug or feature items that do not have a corresponding ID associated with them are internally identified.

3.3.41

Cloud Analytics Server
Released on August 29, 2020

New Features

Designer

  • Combine Widgets: Ability to combine more than one widget in a single container has been added.
  • Combine data source: Support for combining data sources to union the extracted data is now available.
  • Data Preview: The option added for data preview to be on or off in the data source designer.

Widgets

  • Logarithmic axis: The logarithmic axis is now added to charts for both primary and secondary axis.
  • Legend Title: Support to add a title for the Chart legend has been added.
  • Included “All” option in the Combo box filter widget.
  • The vertical text alignment is now supported in the RTE widget.
  • Provided an option to change the grid data bar color.
  • Provided an option to show/hide grid header and grid border.
  • Provided an option to change the foreground and background color of grid rows and alternate rows.
  • Provided an option for Column Resize and Fit to Content in Pivot Grid.
  • Provided an option to load marker using postal code / addresses in Bing map.
  • Provided an option to set background color / background image for widgets.
  • Provided an option to change the font color in all cartesian charts, heat map, map, range navigator, range slider.
  • Now combination chart supports to show both bar and line type series at same time.
  • Support to view the underlying data and performing linking operation in Bing map.

Data Sources

  • Now, you can connect and create dashboards with the following new data sources.
    • Influx DB
    • SQLite with extract mode
  • The extract mode is now supported for the Snowflake connector.
  • More Expressions:
    • Added support for 8 aggregations, 4 conditionals, 3 logical, 4 dates, and 6 string expressions in SSAS.
    • Added support for 4 numbers, 1 conditional, 5 dates, and 2 string expressions in the SQL data sources.
  • Support to connect Azure SSAS with the existing Microsoft SSAS connector has been added.

Server

  • Data Security features: Support for Custom Attributes have been added for filtering data across groups and users.
  • Data Alerts: Data driven alerts through email is now available in Bold BI.

Improvements

Designer

  • Improved designer canvas: The improved cell structure in the new designer canvas offers more granularity over the widget size.
  • UX Improvements: Fonts and colors of the dashboard elements have been improved for better visibility across different screen resolutions.
  • Parameter Improvements: Support for display text and value text in dashboard parameters have been added.
  • Expression Improvements: Expressions are now supported in code view.

Widgets

  • Grid Improvements:
    • Now, the HTML content can be rendered in the Grid widget.
    • Alternate Rows: Support to highlight the Grid alternative rows is available now.
    • Alignment: Now, the Grid widget has the option to align the columns and headers.
  • Gauge Improvements:
    • An option to show or hide the actual and difference value in gauge has been added.
    • Support for a circular gauge has been added.
  • Map Improvements: Multi-selection support in map widget has been added.
  • Widget actions: Now, the widget interactions have been improved for better usability in the linking scenarios.

Data Sources

  • Improved stability for Zendesk Support data source pagination and data source refresh.
  • Added support for custom UI in QuickBook Online and QuickBooks Payment data sources.
Note : The bug or feature items that do not have a corresponding ID associated with them are internally identified.

3.3.40

Windows
Released on July 29, 2020

New Features

  • Render multiple instance: Support for rendering multiple instances of dashboard or widgets in the same page has been added.
  • Embed Designer: Support for embedding dashboard designer for adhoc reports creation has been added.

Designer

  • Combine Widgets: Ability to combine more than one widget in single container has been added.
  • Combine data source: Support for combining data source to union the extracted data is now available.
  • Data Preview: Option added for data preview to be on/off in data source designer.

Widgets

  • Logarithmic axis: Logarithmic axis is now added in charts for both primary and secondary axis.
  • Legend Title: Support to add title for the Chart legend has been added.
  • “All” option included in the Combo box filter widget.
  • Vertical text alignment is now supported in RTE widget.

Data Sources

  • Now, you can connect and create the dashboards with following new data sources.
    • EDI
    • SQLite
    • Influx DB
    • A separate connector for CData
    • LinkedIn
    • Zoho
    • Zendesk CRM
    • Commvault
    • Xero
    • Lessonly
    • SAP Hana data source through ODBC.
  • Extract mode is now supported for Snowflake connector.
  • Enum data type is now supported for MySQL data source.
  • More Expressions:
    • Added support for 8 aggregation, 4 conditional, 3 logical, 4 date and 6 string expressions in SSAS.
    • Added support for 4 numbers, 1 conditional, 5 date and 2 string in expressions in SQL data sources.
  • Support to connect Azure SSAS with existing Microsoft SSAS connector has been added.
  • Added iterative mode support for dashboard parameter when using parameter list in Web API.
  • Driver options: support for choosing the driver is now available for ODBC data connections.

Server

  • Publish Module: Support for publishing dashboards from one server to another has been added.
  • Data Security features: Support for Isolation codes and Custom Attributes has been added for filtering data across tenants.
  • Support for hosting Bold BI as website under another site in IIS is now available.
  • Localization: Localization ability is now available for both application and data.
  • Data Alerts: Data driven alerts through email is now available in Bold BI.

Improvements

Designer

  • Improved designer canvas: The improved cell structure in the new designer canvas offers more granularity over the widget size.
  • UX Improvements: Fonts and colors of the dashboard elements have been improved for better visibility across different screen resolutions.
  • Parameter Improvements: Support for display text and value text in dashboard parameters has been added.
  • Expression Improvements: Expressions are now supported in code view.

Widgets

  • Grid Improvements:
    • HTML content can now be rendered in the Grid widget.
    • Alternate Rows: Support to highlight the Grid alternative rows is available now.
    • Alignment: Grid widget now has option to align the columns and its headers.
  • Gauge Improvements:
    • Option added to show or hide the actual and difference value in gauge.
    • Support for full circular gauge has been added.
  • Map Improvements: Multi selection support in map widget has been added.
  • Widget actions: Widget interactions has now been improved for better usage in linking scenarios.

Data Sources

  • Data connection wizard has been revamped for the below data connections, for better usability.
    • Survey Monkey
    • Amazon MWS
    • Club ready
    • Facebook
    • Slack
    • Stripe
    • Shopify
    • Bitly
    • Facebook Ads
  • Increased file data source limit to 200 MB.
  • Increased Web API max row limit to 1 million.
Note : The bug or feature items that do not have a corresponding ID associated with them are internally identified.
Live Chat Icon For mobile
Hugo Morris

Chat with the Bold BI Sales team now!

Live Chat Icon