Bold BI Release History - 3.3
3.3.119
Cloud Analytics Server
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
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
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
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
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
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
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
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
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.
- Now, you can connect and create dashboards by using the following
new 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
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
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
- 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
- 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.