FAQ
Here are some answers to the most frequently asked questions about BMC Helix Dashboards.
Frequently asked questions about additional resources
Where can I find more details about BMC Helix Dashboards?
Watch this webinar to gain more insights into BMC Helix Dashboards: Webinar: Introduction to BMC Helix Dashboards.
Is there a webinar where I can learn the basics of BMC Helix Dashboards?
To learn the basics of BMC Helix Dashboards, see Introduction to BMC Helix Dashboards.
Frequently asked questions about migrating and transitioning
How can I transition from Smart Reporting to BMC Helix Dashboards?
For information about transitioning from Smart Reporting to BMC Helix Dashboards, see BEST FAQ on transitioning to BMC Helix Dashboards.
How can I migrate BMC Helix Dashboards content between environments?
To learn about migrating BMC Helix Dashboards content between environments, see Exporting and importing dashboards.
How can I migrate content from Smart Reporting to BMC Helix Dashboards?
To learn how to migrate content from Smart Reporting to BMC Helix Dashboards, see Smart Reporting to BMC Helix Dashboards - Prerequisites and How to run.
Frequently asked questions about walkthrough of Dashboards
How can I configure a dashboard, panel, and queries?
In BMC Helix Dashboards, a dashboard displays information from various data sources in panels organized in rows. You can use different visualization types in different panels of the dashboard. For more information, see Setting up Dashboards.
What query type should I choose while creating a new panel on dashboard: SQL query type or Form Type?
To know about query types and which one you should choose, see Webinar: Helix Dashboards Examples Addressing Common Requests.
How can I create and manage scheduled content?
For information about scheduling and managing content, see Webinar: BMC Helix Dashboards examples addressing common requests.
How can I use advance functions, variables and links effectively?
For information about advance functions, variables, and links, see Webinar: BMC Helix Dashboards examples addressing common requests
How to improve Dashboard performance?
If the Dashboard query checks null and not null values, it is best to set the default GUI ID in the variable configuration for all as a best practice to refrain from the query. This will increase the dashboard's performance.
You can also increase the Max Entries Return by the Get list limit as needed.
For more information, see Best practices for service management dashboards.
How can we use the conversion tool?
For information about the conversion tool, see BMC Helix Dashboards - Transition From ITSM Smart Reporting To BMC Helix Dashboards.
Are there any best practices for SQL queries?
For information about the best practices for SQL queries, see BMC Helix Dashboards - ITSM Advanced Report Design Best Practices.
How can I enable the tables and functions required to support DBFN functionality on the Converged platform database?
To enable the tables and functions required to support DFBN functionality, use any one of the following methods:
Execute the script manually.
For more information, see Helix Support: DFBN FunctionsUse the javadriver utility.
For more information, see Defining database functions in AR System server
After the required tables and functions are enabled, you can define the database function in the AR System and use them in the BMC Helix Dashboards. For more information, see Defining database functions in AR System Server.
What distribution of Grafana is embedded with BMC Helix Dashboards?
BMC Helix Dashboards includes Grafana Open Source Software (OSS). The following table lists the BMC Helix Dashboards versions and the corresponding Grafana versions:
| BMC Helix Dashboards version | Grafana version |
| 25.2 | 11.2 |
| 25.1, 25.1.01 | 10.4.2 |
| 24.4, 24.4.01, 24.4.02 | 10.4.2 |
| 24.3, 24.3.01, 24.3.02 | 10.4.2 |
| 24.2, 24.2.01, 24.2.02 | 9.5.3 |
| 24.1, 24.1.01, 24.1.02 | 9.5.3 |
| 23.3, 23.3.01, 23.3.02 | 9.5.3 |
| 23.2, 23.2.01, 23.2.02 | 9.5.1 |
| 23.1, 23.1.01, 23.1.02 | 9.5.0 |
| 22.4.02 | 9.2.2 |
| 22.4 and 22.4.01 | 9.0.2 |
22.3.01, 22.3.00, 22.2.01 | 8.4.5 |
22.2.00, 22.1.01, 22.1.00 | 8.3.3 |
| 21.3.03 | 8.2.5 |
Which languages does BMC Helix Dashboards support?
English is the default language of the BMC Helix Dashboards application. In addition, various other languages are supported. Localization in non-English locales is limited to screens commonly used by reporting users. The Dashboard panel builder screens used by Dashboards developers are available only in English. For more information, see Localizing-the-content-of-dashboards.
How to handle null values in a dashboard?
To know about handling null values, see the section To display the filter data with NULL values on Setting-up-variables-for-dashboard-queries.
How to add data links in Helix Dashboards?
For information about adding data links in BMC Helix Dashboards, see Adding-overrides-to-fields-in-a-dashboard.
How to use a dashboard panel as a data source?
To use a dashboard panel as a data source, perform the following steps:
- Create a new dashboard.
- Create a panel with 4 or 5 field values.
- Save the dashboard.
- Add a new panel and select the datasource as --Dashboard--.
- Select a required source from the Source panel.
- Refresh the panel.
- Add visualization as required.
- Save the dashboard.
How can I generate multiple queries in a single panel on BMC Helix Dashboards?
Configuring multiple queries is useful when you need to fetch data based on a selected time range and filter the results based on a common filter. For example, in any service dashboard, the Health Score, Events, and Incidents panels use multiple queries.
Perform the following steps to generate multiple queries in a single panel in Helix Dashboards:
- Create a blank dashboard panel and save it.
- Edit the panel.
- Add a query as required.
- Click Add query to add another query.
Similarly, add multiple queries as required. - Save the panel.
How do we handle special characters in Variable values?
BMC Helix Dashboards includes the following Variable formatting options:
$variable:bmcsinglequote
Use the variable format: bmcsinglequote for variable values containing single quotes and numbers.InformationExampleSELECT
`myit-sb:ServiceRequest`.`Request ID`
FROM `myit-sb:ServiceRequest`
where `myit-sb:ServiceRequest`.`Request ID` = ${RequestID:bmcsinglequote}$variable:base64
Use the variable format $variable:base64 for variable values that you want to pass in the drill through the URL and then must be converted to base64.InformationExample/../monitor/#/monitoring/events/${__data.fields._identifier:base64}
To see the complete list of available variable formats, see Available variable formats in Grafana.
How to use transform?
For information about using transform, see Transform data.
How to generate a co-display report?
To generate a co-display report, you must configure repeating rows and repeating panels.
For information about configuring repeating rows, see Configuring repeating rows.
For information about configuring repeating panels, see Configuring repeating panels.
How can I add dynamic fields to a BWF report?
To add dynamic fields to a BWF report, see BWF Dynamic Data Handling in Helix Dashboards.
How can I create calculated fields in Metadata Views?
To create calculated fields in the Metadata views, see Creating customized views.
Frequently asked questions about user roles, user permissions, and user groups
What are the differences between roles and permissions?
Roles are defined by tenant administrators in BMC Helix Dashboards. For more information, see Roles-and-permissions.
How to grant permission and assign roles in Helix Dashboards?
For information about granting permissions and assigning roles, see Roles-and-permissions.
How to create a new team or group in Helix Dashboards?
Helix Dashboards groups can only be administered from the BMC Helix Portal UI.
For more information, see Create a new team or group in Helix Dashboards.
Frequently asked questions about out-of-the-box dashboards
Can I modify the out-of-the-box content?
No, you cannot edit or delete out-of-the-box content. You can save an out-of-the-box dashboard with a different name as a custom dashboard and then modify it later. This restriction also applies when you are adding tags. For more information, see Viewing out-of-the-box dashboards.
Frequently asked questions about Reporting Metadata Studio
How to install and start using Reporting Metadata Studio?
For information about installing and using Reporting Metadata Studio, see Installing-and-upgrading-Reporting-Metadata-Studio.