Cisco Unified Intelligence Center Report Customization Guide, Release 10.5(1)
Reports in Unified Intelligence Center
Downloads: This chapterpdf (PDF - 1.23MB) The complete bookPDF (PDF - 2.58MB) | The complete bookePub (ePub - 296.0KB) | The complete bookMobi (Mobi - 390.0KB) | Feedback

Reports in Unified Intelligence Center

Reports in Unified Intelligence Center

There are three types of reports based on the query types:

  • Historical report—Receives data from the historical data source. Reports are populated with interval data that has a default refresh rate of 15 minutes. Historical reports have an upper limit of 8000 rows.

  • Real-time report—Receives data from the real-time data source. Reports are populated with interval data that has a default refresh rate of 15 seconds. Historical reports have an upper limit of 3000 rows.

  • Live Data report—Receives data from the Java Message Service (JMS) data source.

A report in Unified Intelligence Center is made up of the following components.

Data Source

The Data Source defines the sources which contain the data for the report. Unified Intelligence Center supports three types of databases: Microsoft SQL Server, IBM Informix, and Java Message Service (JMS). The data source should be preconfigured for you. If it is not, contact your administrator to configure the appropriate data source.

For more information, see Data Sources.

Report Definitions

Each report has a Report Definition, which represents how data is retrieved from the data source for that report template. In addition to specifying how data is retrieved (by a simple MS SQL query, stored procedure query, real time streaming or an anonymous block query), a report definition contains the dataset that is obtained. This includes the fields, filters, formulas, refresh rate, and key criteria field for the report.

For more information, see Report Definitions.

Reports

Reports show data returned by Report Definitions. This data is extracted by database queries.

Time Zone Conversions

The time zone conversion happens if there is a difference between the user and the data source time zones.

Daylight savings time consideration for Database Query Reports: The Daylight savings time offset at the start of the date range is considered for the time zone conversion when the report is filtered. If the daylight savings change occurs somewhere in between the filter date and time ranges, the time zone offsets will not be computed properly if the user and the data source are in different time zones. In this case, you will have to split the time filter such that separate report invocations are run before and after the daylight savings time change.


Note


The daylight savings time offset depends on the latest system time zone library.


Example 1:

User time zone: Australia/Sydney

Data source time zone: America/New_York

Daylight savings time changes: +1 hour for Sydney at 2013-10-06 02:00 a.m. DST +1 hour is already on for New York

Filter selected by the user: 2013-10-06 to 2013-10-06, 12:00 a.m. to 11:59 p.m.

Query formed in data source time zone: 2013-10-05 10:00:00 a.m. to 2013-10-06 09:59:59 a.m.

Report displayed in user time zone: 2013-10-06 12:00 a.m. to 2013-10-07 12:59 a.m.

In this case, the report will display an extra hour of data as Sydney Daylight savings time is off at the start of the date range and on at the end of the date range.

Example 2:

User time zone: Australia/Sydney

Data source time zone: America/New_York

Daylight savings time changes: +1 hour on for Sydney at 2013-10-06 02:00 a.m. DST +1 hour is already on for New York

Filters selected : 2013-10-06 to 2013-10-10, 03:00 a.m. to 11:59 p.m.

Query formed in data source timezone: 2013-10-05 12:00:00 p.m to 2013-10-06 08:59:59 a.m.

Report displayed in user time zone: 2013-10-06 03:00 a.m. to 2013-10-06 11:59 p.m.

In this case, the conversion happens as expected as there is no Daylight savings time change in between the date ranges.

Example 3:

User time zone: America/New_York

Data source time zone: IST

Daylight savings time changes: +1 hour DST at 2013-03-03 02:00 a.m. and off at 2013-11-03 02:00 a.m. for New York. No Daylight savings time changes for IST.

Filter selected by the user : 2013-11-03 to 2013-11-03, 01:30 a.m. to 05:30 p.m.

Query formed in data source time zone: 2013-11-03 11:00:00 a.m. to 2013-11-03 02:59:59 a.m.

Report displayed in user time zone: 2013-11-03 01:30 a.m. to 2013-11-03 04:30 p.m.

In this case, the report will display one hour less of data as New York Daylight savings time is on at the start of the date range and off at the end of the date range.

Report Views

A report can be presented in multiple formats like a grid, chart, or a graph. Each view can have its own set of fields. A single report can have multiple views.

Report Help

You can attach a help page specifically for your report.

Stock Reports

Cisco provides new stock reports from time to time to be used as templates for new functionality. These reports can be downloaded from Cisco.com.

All the reports reside in the Reports drawer on the left pane.

For more information about creating or editing a report, see Create or Edit Reports.

Create or Edit Reports

All actions on the Reports interface are based on user role and on the user's object permissions for reports and for categories. For more information, see Manage User Permissions.

The following steps describe how to create a new report or edit an existing report.

Procedure
    Step 1   Click the Reports tab in the left pane.
    Step 2   Navigate to the folder where you want to create the report.

    To create a subfolder, navigate to the appropriate folder, right-click on the folder, and select Create Sub-category.

    Step 3   Right-click the folder where you want to create the report and select Create Report.
    Note   

    To edit an existing report, navigate to the report, right-click on the report, and select Edit.

    Step 4   In the Create Report window, enter a name for the report in the Name field.
    Note   

    The name of the report should be unique to Unified Intelligence Center.

    Step 5   Enter a brief description of the report in the Description field.
    Step 6   Select the appropriate report definition in the Report Definition section. Use the arrows to expand the folder.
    Step 7   Assign the appropriate permissions in the Permissions section.
    Step 8   Click OK.

    To configure the help page for a report, see Configure Online Help for a Report.


    Import Reports

    If you have an existing report, you can import that report and the related help files into Unified Intelligence Center. You must zip the report before importing it. The format for storing the report and help content is as shown below:

    Figure 1. Directory Structure of the Report ZIP File

    Each report help folder has a size limit of 3 MB. If the size exceeds this limit, the system does not load the help content. You can import the following: Report, Report Definition, Value Lists, Views, Report Editor values, Thresholds, Drilldowns, Permissions, and Template Help.


    Note


    However you cannot import the Report Filters and Collections.


    To import a report, follow the steps below.

    Procedure
      Step 1   Click the Reports drawer in the left pane.
      Step 2   Navigate to the folder where you want to import the report.
      Note   

      To create a sub-folder, navigate to the appropriate folder, right-click on the folder, and select Create Sub-category.

      Note   

      If you are importing a stock report bundle from Cisco.com, it should be placed at the Reports folder level.

      Step 3   Click Import Report.
      Step 4   In the File Name (XML or ZIP file) field, click Browse.
      Step 5   Browse to and select the XML or the compressed report file, and click Open.
      Step 6   From the Data source for ReportDefinition drop-down list, select a data source used by the report definition.
      Note   

      This field appears only if the report definition for the report being imported is not currently defined in Unified Intelligence Center.

      Step 7   From the Data Source for ValueList drop-down list, select the data source used by the value lists defined in the report definition.
      Note   

      You have to select a data source for the value list only if it does not use the same data source as the report definition. For report definitions of Real Time Streaming, it is mandatory to select a data source for the Value Lists.

      Step 8   In the Save To field, browse to the folder where you want to place the imported report. Use the Arrow keys to expand the folders.
      Step 9   Click Import.