This documentation supports the 19.02 version of Remedy IT Service Management Suite.

To view the latest version, select the version from the Product version menu.

BMC Remedy Smart Reporting version 19.02 enhancements 1

This section contains information about enhancements in the version 19.02 of BMC Remedy Smart Reporting:

Related topics

Downloading the installation files

Known and corrected issues

Release notes and notices

Additional Remedy ITSM 19.02 enhancements

BMC Remedy Smart Reporting enhancements

The following sections provide information about the enhancements in the 19.02 release.


For a Remedy Smart Reporting administrator to run a custom database function, the Remedy AR System administrator must first define the function in the Remedy AR System Server. For more information, see  Defining database functions for Remedy Smart Reporting in Remedy AR System Server .

Ability to execute database functions defined in Remedy AR System Server by using Freehand SQL

In versions earlier than 19.02, a Remedy Smart Reporting report writer could run a pre-defined set of JDBC functions only. In version 19.02, a Remedy Smart Reporting report writer can run and use any database function by using the Freehand SQL calculated field builder in reports and views. For more information on Freehand SQL, see Freehand SQL.

Ability to create custom reports by using Advanced Authoring

You can now create custom reports by using complex AR JDBC compliant queries. For this, a new option Advanced Authoring is supported by Remedy Smart Reporting. After you enable this option, you can use the SQL Query editor to write complex database queries for creating reports. For more information about Advanced Authoring, see Advanced Authoring.

Ability to present business metric using Stories

You can use Stories to present the business metrics by embedding reports, narratives, and relevant data. You can share stories with users without any external tools such as email. Based on your data analysis, inputs from colleagues, and comments from users, you can decide the next plan of action. For more information, see Stories.

Automated Insights

BMC Remedy Smart Reporting provides automated insights to your questions without you having to search the data or analyse it. The assisted insights functionality finds the data to analyse, analyses the data, comes up with the most relevant data and presents it in the form of easy-to-understand narratives or visualizations. For more information, see Assisted Insights.

Report builder

The following enhancements are made to the report builder:

  • Add to Story—You can now include a report in a story by using the new Story icon on the report out page.
  • Snapshots—The Snapshot icon is moved to the left side of the report output page. Additionally, you can easily add the snapshot to a story using the Add to Story button on the Create Snapshot wizard.

  • Bookmarks—The Bookmarks icon is moved to the left side of the report output page. Additionally, you can easily add the bookmark to a story using the Add to Story button on the Create Bookmark wizard.
  • Annotations—UI enhancements are made to the report and chart annotations, such as refined look of the annotation flag that also displays total number of overlapping annotations, updated look for the annotation roll over with the ability to navigate back and forth for overlapping annotations. Additionally, you no more add tags to annotations.
  • Time sliderThe look and feel of the time slider is enhanced.
  • Trending in crosstab chartsCross tab charts now support trend lines.
  • In the chart builder’s series settings, Pivot Series Format field is renamed to Series format.

  • Chart series format settingsYou can now directly update the format of individual chart series, add new values, or populate the list with existing values. You can configure series format name, format style, custom color toggle, color selection, border color and width, and settings to display conditional formatting alerts.

  • Chart series color settingsThe Chart Series option is enhanced to include configurations for the chart’s colors. You can now configure the legend sort order, data sort direction, color by reference code, or color by custom monochrome selection.

  • Advanced function now allows users to load their data models into the platform and use them.

  • A smart analysis button is added to perform assisted discovery.

Chart builder

The following enhancements are made to the chart builder:

  • A new time series type called Discrete time series is introduced. The Discrete time series allows you to view the chart data at discrete time junctions instead of a continuous flow.

  • The Variance chart function is enhanced to include two more formulas for calculating variances in data—percentage of total variance and percentage change in relative proportion. Additionally, you can also create Set Analysis fields directly from this function.

  • You can now change the date format of discrete time series charts.
  • You can now sort the chart content according to the group order. Additionally, you can also sort the data on a heat grid.
  • You can now direct apply the four basic functions—(average, trend, forecast, and accumulation) to the more advanced functions, like set analysis and variance.
  • You can customize the horizontal or vertical axis titles in auto charts. Additionally, new setting features such as toggle buttons, Show Tick Marks, Axis Style, and ShowTick Labels are added to the style settings of the horizontal and vertical axis.
  • Style settings for chart legends now include features, such as Prefix Field Name, Legend Limit, Legend Item Shape, Show Trends in Legend, Variance Field Names, and Color Range Values.

  • In a time series chart, you can now assign colors based on the range of numeric values.


The following enhancements are made to the Tooltips:

  • The tooltip is enhanced to show more information such as exact values, sum of values, color coded values in case of multiple data, and so on. Features such as auto analysis, filtering content, and data drilling have made the toottips very interactive.


The following enhancements are made to Clustering:

  • Dynamic and Repository clustering infrastructure is enhanced to include master-slave functionality for handling background tasks, visibility of where a task is running, and a more flexible cluster configuration. For this, you must manually modify the ClusterManagement servlet in the web.xml file to include every background task that may run, for each node. If you do not add the new parameters, the node will not run any background task. For more information, see Setting up BMC Remedy Smart Reporting as a cluster and onboard tenant .
  • The automatic task delegation functionality is enhanced to automatically assign a Master node that assigns and manages nodes to execute tasks.

  • You can now disable nodes. This ensures that the enabled nodes can process web requests, without having to compete with the background tasks for system resources.

For more information on Clustering, see Clustering.

UI changes

Remedy Smart Reporting version 19.02 offers the following UI enhancements:

Create Button

The Create button now includes an option Story to create a new story.

Browse options
  • A new Stories option is now available under Browse in the left navigation pane to browse through all stories.

  • Views is moved to Browse options from Administration.

What else changed in this release

In this release, note the following significant changes in the product behavior:

UpdateProduct behavior in versions earlier than 19.02Product behavior in version 19.02

Ability to use any database function to create custom reports

In version earlier than 19.02, a Remedy Smart Reporting administrator could use only a pre-defined set of database functions for reporting purposes.

Starting from version 19.02, a Remedy Smart Reporting administrator can execute and use any database function for creating custom reports by using the Freehand SQL option.

Improved Export/Import User InterfaceIn versions earlier than 19.02, you could export and import limited content.In version 19.02, you can export and import the semantic views, reports, and other reporting content across environments.
Was this page helpful? Yes No Submitting... Thank you