This documentation supports the 21.3 version of Smart Reporting.

To view an earlier version, select the version from the Product version menu.

BMC

BMC Helix ITSM: Smart Reporting 21.3

All versions
BMC Helix ITSM: Smart Reporting (Smart Reporting) is an easy-to-use, web-based report writer for designing reports with rich data visualization, interactive charts, and cross-application data. Using Yellowfin technology as the platform, Smart Reporting offers drag-and-drop simplicity for formatting and data selection.

Release notes and notices
updated 07 Mar

Learn what’s new or changed for BMC Helix ITSM: Smart Reporting 21.3, including new features, urgent issues, documentation updates, and fixes or patches. 

Tip

To stay informed of changes to this space, place a watch on this page.

Related topics

Known and corrected issues

Action Request System release notes Open link

BMC Helix ITSM enhancements Open link

BMC CMDB release notes Open link

DateSummaryReference
January 29, 2024

This patch release contains defects fixes for BMC Helix ITSM and BMC Helix ITSM: Smart IT.

21.3 patches
September 5, 2023

This patch release contains defect fixes for BMC Helix ITSM , BMC Helix ITSM: Smart IT, and updates for BMC Helix Service Management deployment. 

21.3 patches
June 15, 2023

Patch 9 for version 21.3 is available for SaaS customers.

This patch release includes defect fixes for BMC Helix ITSM.

21.3 patches
December 7, 2022

This patch release includes updates and defect fixes for BMC Helix ITSM: Smart IT and BMC Helix ITSM.

21.3 patches
May 26, 2022

This patch release contains defects fixes for BMC Helix ITSM and BMC Helix ITSM: Smart IT.

21.3 patches
March 23, 2022

This patch release contains defects fixes for BMC Helix ITSM and BMC Helix ITSM: Smart IT.

21.3 patches
February 8, 2022

This patch release contains defects fixes for BMC Helix ITSM and BMC Helix ITSM: Smart IT.

21.3 patches
January 20, 2022

Patch 2 for version 21.3 is available for BMC Helix subscribers (SaaS). This patch release includes the following update for BMC Helix ITSM:

  • BMC Service Request Management is available only for upgrade scenarios for existing customers
  • Enhance knowledge article management by integrating BMC Helix Knowledge Management by ComAround
21.3 patches
January 5, 2022

Patch 2 for version 21.3 is available for on-premises customers. This patch offers support for BMC Helix ITSM Insights and BMC Helix Dashboards deployment.

21.3 patches
November 19, 2021

This patch release includes updates and defect fixes for BMC Helix ITSM: Smart IT and BMC Helix ITSM.

21.3 patches
October 4, 2021

Enhancements available in this release:
BMC Helix ITSM: Smart Reporting is available only for upgrade scenarios for existing customers

21.3 enhancements

Onboarding

 

Onboarding users.

Using

 

Interface descriptions, using the product.

Administering

 

Information to set up user accounts, to manage and maintain the system after it is installed and configured.

Integrating

 

Integrations with other products.

Troubleshooting

 

Issues resolution, logs, and contacting Support.

Communities

Knowledge Base

Videos

Videos

Education

PDFs and videos

or register to view the contents of this page.

Smart Reporting videos

The following topics contain videos that supplement or replace the text-based documentation:


YouTube playlists

Smart Reporting video playlist Open link

Yellowfin video playlist Open link

Frequently asked questions

 

The information in this FAQ supplements the BMC Helix ITSM: Smart Reporting(Smart Reporting) documentation. It contains the following sections:

Installation and deployment

Yes. Smart Reporting provides flexible deployment options. You can achieve different levels of isolation for reporting to account for varying workloads.

In the simplest deployment, the reporting server shares the infrastructure with Mid Tier.

In more advanced deployments, you can configure Smart Reporting on a separate reporting server or a reporting cluster. This deployment model separates any reporting workload from Mid Tier, although they still have the AR System server(AR System server) and database in common.

The reporting administrator can export and then import reports, and other definitions by using an XML based import-export feature available in Smart Reporting.

The AR System JDBC driver connects only to the AR System server. Internally, the AR System APIs connect to the AR System database.

The reporting server uses Apache Tomcat as the default web server. The metadata-like report configuration for Smart Reporting is added to separate tables in a database that can be shared with AR System.

Installing both AR System and BMC Helix ITSM components will also install Smart Reporting capabilities. After completing the installations, the administrator must run a Smart Reporting onboarding utility that imports the report definitions. After onboarding is complete, no additional configuration is required, and all the out-of-the-box content is available. For more information, see the following resources:

Smart Reportingcustomizations

Smart Reporting is available for both BMC Helix ITSM and custom forms within it. Content related to BMC Helix ITSM, including reports, dashboards, and views is provided out of the box. To use custom forms, you must add them to the semantic view of Smart Reporting.

No. Smart Reporting does not support exporting the report data into XML format. Smart Reporting exports only the report definition into XML format, which may not be compatible with other tools. When you export the reports to other formats (such as CSV, Excel, and PDF), they contain the report data and not the report definition.

You can extend out-of-the-box joins, which are already defined based on the semantic layer. For custom forms, you must know the join fields and define them as part of the view definition.

All fields, except view-only fields and vendor forms are available for reporting. Out-of-the-box views contain only the most widely used fields. You can easily extend the out-of-the-box views to include additional fields; however, you should always create a copy of the out-of-the-box view and then modify the copy.

No. The administrator must first publish the custom fields as a part of the semantic view through quick configuration steps using the drag-and-drop interface.

Dates are preformatted in Smart Reporting. You can also choose different date formats. 

Smart Reportingcharts, report designer, and self service

No, but you can create line charts with upper and lower controls and targets by selecting the KPI option from the Report Design screen. See Example: Creating a Change Management KPI report. 

Yes. Any dashboard is completely configurable.
You can arrange the tabs on a dashboard according to the content available out of the box, such as IT Infrastructure Library (ITIL) processes like Change Management, Incident Management, and Knowledge Management.
You can also configure the tabs for different departments. If you want to set up different dashboard tabs per department with the same underlying report definitions, you can also leverage the dashboard page filters. These filters ensure that although the dashboard pages are similar, the data displayed on each dashboard tab is specific to each department.

Smart Reporting is a self-service tool. Customers can configure the reporting themselves.

Specific roles govern access rights in Smart Reporting. Users with a role to create new reports can define new reports for report consumers. See Managing Smart Reporting user roles and groups.

Yes. With appropriate permissions in Smart Reporting, users can remove or modify a report, or copy an existing report and modify their own copy. However, BMC recommends that you do not modify or remove an out-of-the-box report.

Administrators can set server-level format settings that apply to all reports by default. Currently, the concept of a template for report formatting is not available.

Historical or aggregated data, such as Mean Time To Resolve (MTTR), is available in out-of-the-box KPI reports. KPI reports leverage the flashboard functionality in the server (not the visualization) to capture and store historical information for key performance indicators (KPIs). With version 9.0, Incident Management and Change Management KPIs are available out of the box, and more KPIs for other areas will be added over time.

Yes. Relationships are available in the out-of-the-box views (semantic layer) for BMC Helix ITSM applications.

Yes. Reports are available in the Smart Reporting interface. You can schedule reports using different broadcast options, and you can send the reports via email.

Smart Reporting is not an active monitoring system like BMC ProactiveNet Performance Management. However, it supports a few business cases for exception reporting. For example, you can configure conditional report delivery to send an email when more than 10 critical incidents are assigned to any of your team members. Based on the frequency you define, the report can run every few minutes or hours, but will send an email only when more than 10 critical incidents occur as defined in the qualification.

No. You cannot limit report scheduling to a specific time frame.

Yes, webinars dedicated for report creation are available. For more information, see  Smart Reporting - Best Practice Resources.

Yes, you can view and manage private reports created by other users. For this, you must have content super user access. For more information, see Granting Content Super User permission to access and manage all content.

Smart Reportinglicensing

Customers with Helix application-level user licenses of type Fixed or Floating are entitled to use Smart Reporting component for reporting on Helix platform-based BMC Helix ITSM applications or extensions thereof.

For custom Helix applications, a customer is entitled for 7 users who can use Smart Reporting for reporting against such custom Helix applications. Reporting on non-ITSM based applications beyond these 7 users or reporting from non-ITSM data source requires a separate Yellowfin license.

Smart Reporting is focused on providing an in-application reporting solution for BMC Helix ITSM use cases. There are no plans to integrate it with BMC ProactiveNet Performance Management, Data Center Automation, or Cloud Lifecycle Management.

Separate licensing is not required for Smart Reporting. You have access to Smart Reporting with a BMC Helix ITSM license.

Smart Reporting is licensed for BMC Helix ITSM customers. Options for other customers who use AR System without BMC Helix ITSM applications are being discussed.

Smart Reporting license terms allow BMC Helix ITSM customers to generate reports with the AR System database (forms). You cannot integrate Smart Reporting directly with external data sources such as Microsoft Excel, CSV, or XML files; or with any other databases.
However, you can integrate AR System with external data sources to make the data available in AR System forms, which can then be used for Smart Reporting.

You are entitled to use Smart Reporting with a valid BMC Helix ITSM license. So, you can continue to use Smart Reporting while the BMC Helix ITSM license is valid. Also, BMC will provide new version of the license key for Smart Reporting from time to time in future releases, which will extend the term of Smart Reporting.

No. However, you can configure alerts from the License Management panel of the Admin Console.

Convergence of Reporting Technologies (BIRT, D&A, Smart IT)

Cross-launching to Smart IT requires configuration. For detailed steps, see Configuring settings to cross-launch reports.

BMC Analytics for BSM is now obsolete and out of support. Smart Reporting is the replacement for this tool. For more information, see End Of Life Support For BMC Analytics.

No. A utility to convert BIRT and SAP Business Objects reports to Smart Reporting format is not available. However, BMC is working on converting some of the current out-of-the-box BIRT and SAP Business Objects reports in Smart Reporting format, and making the reports available on BMC Communities, which customers can easily import to Smart Reporting. More details will be announced on BMC Communities.  

Yes. You can access Smart Reporting from Smart IT 1.2 or later.

Smart Reporting compatibility, localization, and training

Yes. All supported BMC Helix ITSM languages (except Russian and Korean) are available with Smart Reporting .

The BMC documentation site,  https://docs.bmc.com/ Open link , includes short videos about various Smart Reporting topics such as creating new reports and dashboards. BMC Education also helps customers learn about Smart Reporting.

Smart Reporting is a new capability that is currently aligned with BMC Helix ITSM 9.0 or higher.

Yes. Smart Reporting has the same browser compatibility as the corresponding BMC Helix ITSM version, which supports Google Chrome, Microsoft Internet Explorer, Mozilla Firefox, and Apple Safari (for Macintosh computers).

Out-of-the-box reports and dashboards are available to all the users, including the BMC Helix customers. Further, customers can build their own reports and dashboards from the web-based report designer, without requiring administrator rights. BMC Education and BMC documentation will help all customers to learn about Smart Reporting.

Smart Reporting supports the following Yellowfin builds and versions.

Smart Reportingversions

Yellowfin builds

Yellowfin version

19.11

20191025

8.0.2

For more information, see the Knowledgebase Article Smart Reporting - Version information.

Smart Reporting Security settings

The JSessionID cookie carries information about the user's session but does not have the secure attribute set. This secure attribute helps the browser to send the cookie only if the request is being sent over a secure channel such as HTTPS and protects the cookie from being passed over unencrypted requests.

To secure the JSessionID cookie, complete the following steps:

  1. Edit the web.xml file located at C:\Program Files\BMC Software\ARSystem\SmartReporting\appserver\webapps\ROOT\WEB-INF and include the secure attribute in the server response by adding the highlighted code as shown below:
    <session-config>
    <session-timeout>90</session-timeout>
    <tracking-mode>COOKIE</tracking-mode>
    <cookie-config>
    <http-only>true</http-only>
    <secure>true</secure>
    </cookie-config>
    </session-config>
  2. Open the web.xml file located at C:\Program Files\BMC Software\ARSystem\SmartReporting\appserver\webapps\AdminConsole\WEB-INF and add the following code:
    <session-config>
    <cookie-config>
    <http-only>true</http-only>
    <secure>true</secure>
    </cookie-config>
    </session-config>

Note

The secure parameter is applicable to Tomcat version 7 and later.

The BMC Documentation portal gives you the ability to generate PDF and Microsoft Word documents of single pages, and to create PDF exports of multiple pages in a space.  

Creating PDF and Word exports

You can create a PDF of a page or a set of pages. (Non-English page exports are not supported.) You can also create a Word document of the current page.

To export to PDF or Word

  1. From the Tools menu in the upper-right, select a format:
    • Export to Word to export the current page to Word format
    • Export to PDF to export the current page or a set of pages to PDF
  2. If exporting to PDF, select what you want to export:
    • Only this page to export the current page
    • This page and its children to export a set of pages
    For example, selecting This page and its children from the home page exports the entire space to PDF.


 

Depending on the number of topics included in the export, it might take several minutes to create the PDF. Once the export is complete, you can download the PDF.

Perform the following steps to secure tomcat version 8.5.x:

  1. To generate a key store file, navigate to the jdk bin folder located at C:\Program Files\Java\jdk1.8.0_111\bin, and run the following command:

    keytool.exe -genkeypair -keyalg RSA -alias tomcat -keystore "C:\keystore\keystore.jks" -storepass changeit -validity 36000 -keysize 2048 -dname CN=localhost,OU=OrgUnit,O=Org,L=City,ST=State,C=Country

    Important

    Ensure you have the C:\keystore folder in your system.

  2. To generate the certificate, run the following command:

    keytool.exe -export -alias tomcat -keystore C:\keystore\keystore.jks -rfc -file C:\keystore\tomcat.cer
  3. To import certificate to cacerts, copy the cacerts file located at JRE_FOLDER\lib\security\ to C:\keystore, and run the following command:

    keytool.exe -import -alias tomcat -keystore C:\keystore\cacerts -file C:\keystore\tomcat.cer
  4. Validate that the certificate is imported succesfully by running the following command:

    keytool.exe -list -keystore C:\keystore\cacerts

    Verify it shows the tomcat certificate imported in Step. 3.

  5. To copy cacerts to JRE, take a back up of the old file located at JRE\lib\security and copy the latest file from C:\keystore\cacerts to JRE\lib\security.

  6. In the server.xml file located at tomcat/conf/, uncomment the connector block having port 8443:

    <Connector port="8443" protocol="org.apache.coyote.http11.Http11NioProtocol"
    maxThreads="150" SSLEnabled="true" scheme="https" secure="true"
    clientAuth="false" sslProtocol="TLS" enableLookups="false"
    minSpareThreads="25" maxSpareThreads="75" keyAlias="tomcat"
    disableUploadTimeout="true" acceptCount="100" URIEncoding="UTF-8"
    keystoreFile="C:\keystore\keystore.jks"
    keystorePass="changeit"/>
  7. To enable SSL forwarding, copy the following block in the web.xml file of the webapps, AdminConsole, onboarding and ROOT directories:

    <security-constraint>
    <web-resource-collection>
    <web-resource-name>Automatic SLL Forwarding</web-resource-name>
    <url-pattern>/*</url-pattern>
    </web-resource-collection>
    <user-data-constraint>
    <transport-guarantee>
    CONFIDENTIAL
    </transport-guarantee>
    </user-data-constraint>
    </security-constraint>
  8. Restart the tomcat server.
    If you are using bundled tomcat, access Smart Reporting by using the https://<hostname>:8443/ URL.
    If you are using external tomcat, access Smart Reporting by using the https://<hostname>:8443/SmartReporting/ URL .

Was this page helpful? Yes No Submitting... Thank you

Comments