BMC Remedy Smart Reporting version 19.02 enhancements
This section contains information about enhancements in the version 19.02 of BMC Remedy Smart Reporting:
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 .
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.
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.
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 slider—The look and feel of the time slider is enhanced.
- Trending in crosstab charts—Cross 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 settings—You 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 settings—The 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.
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 .
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.
Remedy Smart Reporting version 19.02 offers the following UI enhancements:
A new Stories option is now available under Browse in the left navigation pane to browse through all stories.
What else changed in this release
In this release, note the following significant changes in the product behavior:
|Update||Product behavior in versions earlier than 19.02||Product 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 Interface||In 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.|