Cisco Cisco Prime Service Catalog 10.0 Technical References

Page of 82
 
1-18
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Chapter 1      Advanced Reporting Data Mart
  Advanced Reporting Module
The dimensions and facts are grouped within the corresponding folders. In addition, the Organizations 
folder holds data on the organizations, groups, and people in use at the site. The Service Bundles folder 
holds data on the service bundles and child service which were associated to the parent service to form 
the bundle.
As you expand the folders, all of the dimensions and facts become visible. Each object designated by the 
icon is a “query subject” which groups a related set of fields or “query items”. Expanding the query 
subject will show its query items.
A query item can be a unique identifier, an attribute or a measure/metric, as indicated by the icon to the 
left of the item name:
Metrics are numbers which can be used in arithmetic expressions. By virtue of an item being defined as 
a metric, its value can be aggregated (for example, averaged, totaled or counted) to provide report totals 
or subtotals when the report or query has several levels or groups. In addition, metrics can be used in a 
wide variety of arithmetic, analytic, and percentage calculations, as specified by the report designer and 
provided by the Cognos tools.
A list of all query subjects and the query items which comprise each subject, with a description of each 
query item, is given in the tables at the end of this section.
Dimensions
The Custom Reports Package includes the following types of dimensions:
Static dimensions are available in all installations, and are listed directly under the Dimensions 
folder. These dimensions describe customers, performers, dates, and other information related to 
tasks and requisitions.
Attribute
Metric