BMC provides a Conversion Tool (find it attached) to ease the content migration from BMC Helix ITSM Smart Reporting to BMC Helix Dashboards.
Minimum requirements to use the Conversion Tool:
- BMC Helix ITSM Smart Reporting 21.05.03 hotfix 10 / 21.3.03 hotfix 5
- BMC Helix Dashboards 22.2.00
- Open JDK 11
- To have the JAVA_HOME environment variable configured
For supported features and known issues refer to:
Running the migration tool - Documentation for BMC Helix Dashboards 24.2 - BMC Documentation
Webinar related to the configuration of the Conversion Tool:
Webinar: Helix Dashboards - How to use the Conversion Tool
Note: You can still use conversion utility if your Smart Reporting version is 20.02 or 20.08, however you should update your Yellowfin license to the latest version if you have Smart Reporting 20.02 or 20.08 versions. Latest yellowfin License file can be uploaded from 20.02 version onwards.
Follow below steps to upload license file:
1. Login to Smart Reporting with "siadmin" to the "Default" organisation
2. Navigate to "Administration" > "Licence Management"
3. Click on "Upload License" section
4. Choose attached file and upload
Release Notes
February/2025
- [DRIAR-4672] Conversion Utility - 4k Automation does not handle StaleElementReferenceException - BMC JIRA Production
- [DRIAR-4700] Conversion Utility - Unable to handle filters with null operators - BMC JIRA Production
- [DRIAR-4711] Conversion Utility - 4k Automation cannot handle date filters having pre-defined range options - BMC JIRA Production
- [DRIAR-4727] Report with calculated field having single/double quotes are not migrating to Dashboards. - BMC JIRA Production
- [DRIAR-4758] conversion utility picks up draft report gets in case of report sql having 4k characters length - BMC JIRA Production
- [DRIAR-4759] Conversion fails for reports having report sql >4k and filter window collapsed - BMC JIRA Production
- [DRIAR-4841] 4k automation doesn't locate a report if selected layout is Thumbnails on UI in SR - BMC JIRA Production
- [DRIAR-4742] Conversion Utility - 4k Automation fails for report having filter which has span element over input box - BMC JIRA Production
February/2024
- [DRIAR-2763] Conversion Utility - 4k Automation does not handle range-type filters - BMC JIRA Production
- [DRIAR-2769] Conversion Utility - 4k Automation cannot locate web elements if the browser is set to a localized language - BMC JIRA Production
- [DRIAR-2773] Uncaught error while iterating variables in dashboard JSON for converted reports - BMC JIRA Production
- [DRIAR-3532] Conversion Utility - Smart Reporting filter titles are not applied (if set) - BMC JIRA Production
November/2023
- [DRIAR-2757] Date fields are exported as text format in BHD XL exported file
- [DRIAR-2756] zip files are empty when broadcasting the dashboards in XLSX and CSV formats.
October/2023
- [DRIAR-2689] Observed for multi chart report, converted dashboard name appended with _TABULAR
- [DRIAR-2699] Duplicate Filters in Dashboards
- [DRIAR-2701] 4k Automation setting placeholder filter values for date filters
- [DRIAR-2715] Range filters converted with single textbox for input
- [DRJ71-7886] SQL query breaks for filters with LIKE operator
August/2023
- Migration of reports containing localized characters: DRIAR-2659, DRJ71-7393
- Format report SQL query to be more readable: DRIAR-2660
- Include TABULAR panel for table-enabled reports in Smart Reporting: DRIAR-2661
- Handle filters applied on VARCHAR fields having both numeric and alphanumeric values: DRIAR-2691
- Handle "All" option for multi-value filters: DRJ71-5800
May/2023:
- Export of scheduled broadcast details on Smart Reporting to a CSV file
- Migration of reports containing HTML hyperlinks
- Support for complex filters in the >4k report SQL automation
- Complete migration of sub-query filters
March/2023:
- Migration of reports whose queries contain >4k characters
- Accurate identification of Smart Reporting filter types
- Validation of support for PostgreSQL, Oracle and MS-SQL databases
- Validation of support for Smart Reporting 20.02.x and 20.08.x versions
December/2022:
- Support for Smart Reporting multi-tenancy
- Support to convert reports containing multiple charts
October/2022:
- Support to Crosstab Reports conversion
- Support to Numeric Display type conversion
- Security vulnerabilities fixes
See also BEST FAQ on Transition to BMC Helix Dashboards