Manage Reports

This section provides detailed information about:

• Creating a new report
• Building the report with reporting widgets
• Widget Sizes
• Removing a Widget from the BizTalk360 Reporting Dashboard
• Editing the Widget Title
• Resizing the Widget
• Restoring the Default Layout of the Dashboard
• Additional Report Operations (Edit, Clone, Delete Report)
• Download PDF
• Live Reports and Historic Reports

Creating a New Report

To create a report in BizTalk360, follow the below steps:

1. Log in to the BizTalk360
2. Select Analytics from the environmental panel
3. Expand the Reporting and select Manage Reports
4. Select the Add Report button at the top of the page. On the Schedule Configuration page,
   • Report Name  - Provide a friendly name for the report
   • Reporting Schedule - Select the reporting schedule that you have already created (see Reporting Schedule to understand the steps to create a Reporting Schedule)
   • Click Save to save the report

5. While creating a report, if you have not configured Performance data collection, you will see a message as shown below asking you to configure Performance data collection.

Configuring Dependencies 

After creating your first report, and in case you have not configured the dependencies, you will see a warning message as shown below asking you to configure the dependencies.

Building the Report with Reporting Widgets

1. Click the Add Widget button at the top right corner of the page to add widgets to your reporting dashboard. We have segregated the widgets based on certain performance metrics such as:

• Predefined widgets 
  • BizTalk Hosts Performance
  • BizTalk Server Performance
  • SQL Server Performance
  • IIS Server Performance
  • Messaging Performance
  • Transmission Failure Rates
  • Monitoring
  • MessageBox KPI
• Secure SQL Queries
• Analytics Custom widgets 

1. Click the + icon to expand the widgets under a category. To add the widget to the Dashboard, click the + icon. The widget will be added to the dashboard and you will see a confirmation message as "Widget added to Dashboard successfully". You will also notice that the + icon changes to x.

Secure SQL Queries

The BizTalk360 Reporting feature includes a widget called Secure SQL Queries, where you can map Secure SQL Queries to such custom widgets (the SQL queries are created under Operations -> Data Access -> Secure SQL Queries). The custom SQL widgets hold the top 100 records of the mapped query and send that as a report on the scheduled time. This feature can be powerful as it enables you to automatically receive reports based on SQL queries, without the need to requesting it manually over and over again!

Let us consider a scenario, where you want to see the Suspended messages count. As a first step, you need to create a query and manually execute it every time to see the Suspended messages. For this, you may need to switch to multiple tools. This is simplified with SQL Query reports; instead of manually executing a query, just create the query and map it to a schedule according to your needs and you will start receiving the query output as a report in your email box.

Creating a Secure SQL Query Widget

1. In BizTalk360, navigate to Analytics and then Reporting
2. Select Manage Reports and select the respective report for which you want to add widgets
3. Click Add Widget to add a new widget to the reporting dashboard
4. Select Secure SQL Queries
5. Provide a Widget Title and select a Secure SQL Query,
   Widget Title - Enter a friendly name for the widget
   Select a Query - Select the query for which you want to get the results as a report Queries can be created/maintained under Operation -> Advanced Services -> Secure SQL Queries
6. Click the Save button
   The Secure SQL Query Widget will now be added to the dashboard.

The saved Secure SQL query widget can be edited and reassociated to any configured Secure SQL query.

Analytics Custom Widget 

Similar to the Analytics Performance dashboard, you can create custom widgets for performance metrics of the BizTalk environment such as Messaging Performance, Message Transmission failure rate, Server Performance, etc., and get it as a report based on the schedule configuration.

Below are some of the BizTalk performance metrics which you can configure as an analytics custom widget and get as a report.

BizTalk and SQL Server Health

• CPU Usage
• Memory Usage
• Disk Free Space
• Average Disk Queue Length
• Network Performance
• IIS Request Per Sec
• IIS Worker Process: CPU Usage
• IIS Worker Process: Memory Usage

Host Performance

• Host Instance performance by CPU
• Host Instance Performance by Memory
• CPU Consuming Host Instances
• Top 10 Memory Consuming Host Instances

BizTalk Messaging Performance

• BizTalk Host Performance
• Documents Receive/Second
• Documents Processed/Second
• Inbound Latency (Sec)
• Outbound Latency (Sec)
• Outbound Adapter Latency (Sec)
• Request -Response Latency

Throttling Performance

• Message delivery Throttling State
• Message Publishing Throttling State
• Message Delivery Outgoing Rate
• Message Delivery Incoming Rate
• Active Instance Count
• Database Size
• Database Session
• Database Session Threshold
• In-Process message Count
• In-Process Message Count threshold
• Message publishing incoming Rate
• Message Publishing Outgoing Rate

Steps to create a Custom Widget

• Log in to BizTalk360
• Select the environment and navigate to Analytics -> Reporting -> Manage Reports
• Open the respective report for widget configuration. Click on Add Widget
• You will notice the Add Widget blade on the right-hand side of the screen. Click the 'Create Analytics custom widget' option in the bottom of the Add Widget blade
• In the 'Create Analytics custom widget ' blade, enter the widget title

• Date Range - Select the date range for the chart. The options are Last 24 Hrs, Last 7 days, Last 30 days, and Custom

  • Last 24 Hrs - Displays the data from the last 24 hours
  • Last 7 days - Displays the data from the last 7 days
  • Last 30 days - Displays the data from the last 30 days
  • Custom - To add a specific number of days, use the scroller to select the day

• Compare with Previous Hour/Day/Month - Select this checkbox to compare the real-time data with the previous hour/day/month

• Compare with the previous option is allowed only for a single metric

• Select the Type of Chart and the legend options

• Choose the performance metrics by selecting the various categories that want to generate as a chart

• Click the Save button

Widget Sizes

The widgets on the dashboard are of specific sizes and can be customized to certain other sizes. The different widget sizes available in BizTalk360 Reporting (with the dimensions) are as follows:

• Compact - 5x4
• Wide - 4x2
• Super wide - 8x4
• Hero wide - 6x4

The below table lists the widgets that can be added to the reporting dashboard, their default sizes (when added to the dashboard), and the possible sizes into which they can be resized.

Removing a Widget from the BizTalk360 Reporting Dashboard

In this section, we will look at the steps to remove a widget from the BizTalk360 Reporting Dashboard. As mentioned in earlier paragraphs, widgets can be added to the Reporting Dashboard. Similarly, a widget can also be removed from the dashboard in three different ways:

• Deselecting an already added widget through the Add Widget section
• Remove a widget through the Customize screen

Deselecting an already added widget through the Add Widget section
Follow the steps as shown below to remove a widget from the reporting dashboard:

1. Click Add Widget, to add widgets to your reporting dashboard or to view the already added widgets to the dashboard
2. You will notice the Add Widget blade on the right-hand side of the screen. The Add Widget blade will list the widgets that can be added to the dashboard
3. Expand a section that contains earlier added widgets, and click the X icon to delete a widget from the dashboard
4. If the widget was successfully removed from the dashboard, you will notice a confirmation message as "Widget deleted successfully". The x icon will change as +
5. Click the Save button to close the Add widget blade. Alternatively, you can click the X on the Add widget blade to close the blade
6. Once the blade is closed, you will notice a confirmation message as Configuration Saved Successfully

Remove a widget through the Customize screen

Follow the steps as shown below to remove a widget via the Customization screen:

1. Click the Customize button. This opens the Customization screen
2. Hover over the widget you want to remove, and click the gear icon in the lower right corner of the widget
3. From the drop-down, select the Remove from Dashboard option
4. Click the Save button to close the Add widget blade. Alternatively, you can click the X on the Add widget blade to close the blade
5. Once the blade is closed, you will notice a confirmation message as Configuration Saved Successfully

Editing the Widget Title

The widgets are loaded on the reporting dashboard with a predefined title. You can change the titles according to your preference by customizing the widget. Follow the steps as shown below to edit the widget name:

• On the dashboard, click the Customize button. You will notice that all the widgets will be in a grayed-out state
• Click on the widget for which you want to change the title. The widget will be activated with the controls required to edit the widget
• Next to the widget title, enter the new title for the widget in the space provided
• Click OK to save the new widget title
• Click Done on the top right corner of the screen to save the dashboard customization

Resizing a Widget

In BizTalk360, when a widget is added to the dashboard, it gets added to the best size where all the information will be visible to the user. However, we have provided an additional functionality where you can customize the size of the widgets as per your requirement.

Before continuing reading this section, we recommend you to read the section that talks about the different widget sizes and the different sizes a widget can be resized.

Follow the steps as shown below to resize a widget. For a better understanding of the functionality, we will consider one widget 'BizTalk Hosts Performance By CPU' which can be found under Add Widget -> BizTalk Hosts Performance. By default, when this widget is added to the dashboard, it will be in the Compact mode (5x4). You can customize this widget to Super Wide mode (8x4).

• In the Reporting dashboard, click the Customize button. You will notice that all the widgets will be in a greyed-out state
• Click on the widget (BizTalk Hosts Performance By CPU) that you want to resize. The widget will be activated with the controls required to edit the widget
• Next to the widget title, click the ellipses (...) icon
• You will notice the options to customize the widget with different sizes. Click the size to which you want to resize the widget
• Click Done on the top right corner of the screen to save the dashboard customization. Alternatively, click the ellipses (...) icon and select Done Customizing from the drop-down
• The widget will be resized to the chosen size

BizTalk360 allows users to customize the dashboard according to their convenience. But, let's say, you accidentally removed a widget, or you want to clean up the dashboard, you can do so using the Restore Default Layout option on the dashboard.

Additional Report Operations - Edit Report   

To edit the report, follow the steps as shown below:

1. Click the Edit Report button. The fields in bold only can be edited
2. Dashboard Name - You can edit the dashboard name
3. Reporting Schedule - Select the reporting schedule that you have already created
4. Click Update to save the report

Additional Report Operations - Clone Report

To easily take a copy of an existing report (widget configurations) and map it to a different reporting schedule, BizTalk360 offers the capability for users to clone a report.

Example: You have a schedule that executes at 7 PM every day. You want another report with the same widgets but to execute at a different schedule - say, 15th of every month at 9 AM. In this case, you don't need to create a new report from scratch. Instead, you can simply clone the existing report and choose the appropriate reporting schedule from the list.

To clone the report, follow the steps as shown below:

1. Click the Report for which you want to clone 
2. Select Clone The fields in bold only can be edited
3. Dashboard Name - Provide a friendly name for the dashboard
4. Reporting Schedule - Select the reporting schedule that you have already created
5. Click Save to save the report

Additional Report Operations - Delete Report

Follow the steps as shown below to delete the report:

1. Click the Report for which you want to delete the report and then hit the Delete button
   You will notice a warning dialog box with the message "Do you want to delete this report? You will lose all your changes. "
2. Click Delete if you want to go ahead and delete the report. Click Cancel to retain the report
   You will see a confirmation message as "Reports deleted successfully"

Download PDF

Follow the steps as shown below to download the PDF:

1. Click the PDF button. The current state of the widgets will be saved as a PDF document

Live Reports and Historic Reports

The Live Data Report shows the data at the current instant based on the System Time. Historic Reports contain the data that was sent in the PDF notification to users at the particular schedule execution.