three types of reports based on the query types:
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
report—Receives data from the Java Message Service (JMS) data
A report in
Unified Intelligence Center is made up of the following components.
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
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.
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.
Non-Daylight Savings Time
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.
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
You can attach a
help page specifically for your report.
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.
cannot import the Report Filters and Collections.
To import a
report, follow the steps below.
drawer in the left pane.
the folder where you want to import the report.
To create a
sub-folder, navigate to the appropriate folder, right-click on the folder, and
If you are importing a stock report bundle from Cisco.com, it
should be placed at the Reports folder level.
Name (XML or ZIP file) field, click
Browse to and
select the XML or the compressed report file, and click
source for ReportDefinition drop-down list, select a data source
used by the report definition.
appears only if the report definition for the report being imported is not
currently defined in Unified Intelligence Center.
for ValueList drop-down list, select the data source used by the value
lists defined in the report definition.
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.
field, browse to the folder where you want to place the imported report. Use
the Arrow keys to expand the folders.