Cisco Unified Intelligence Center Report Customization Guide, Release 10.0(1)
Reports in Unified Intelligence Center
Downloads: This chapterpdf (PDF - 1.17MB) The complete bookPDF (PDF - 2.45MB) | The complete bookePub (ePub - 235.0KB) | The complete bookMobi (Mobi - 384.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 secs. 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.

Reports for Daylight Savings Time

Report fields that show date/time take this value from the database time zone that was entered in the Timezone field of the Data Source. The data source time zone value is automatically updated when the daylight savings time change occurs.

If you generate a report that spans dates before and after the daylight savings time change, the date/time fields for days before daylight savings time reflect that time. The date/time fields for days after daylight savings time reflect the daylight savings time.

Reports For Non-Daylight Savings Time

In Unified Intelligence Center, if you execute a historical report during the daylight savings time period to get data for a non-daylight savings time period, the report fields will display data that is early by an hour.

For example, if you execute a report on April 12, 2013 with date time filter set from 1:00:00 a.m. to 1:59:59 a.m., December 12, 2012, the report will display information from 12:00:00 a.m. to 12:59:59 a.m. on December 12 2012, that is one hour earlier.

You will notice the same behavior for the entire day when the daylight savings time is set back to the non-daylight savings time period. The reports will have the correct date time range only from the day after that midnight.

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.