Technical References

1-19
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Chapter 1 Advanced Reporting Data Mart
Advanced Reporting Module
• The DictionaryData folder lists all dimensions based on dictionaries which were specified as
Reportable, and were therefore loaded into the data mart. Each reportable dictionary is available in
the DictionaryData folder. Each dictionary query subject includes all fields in the dictionary,
whether they were hidden or not in any or all services. One or more dictionary dimension can be
joined with any fact, providing a flexible reporting and filtering mechanism.
• The ServiceData folder contains all services which were specified as Reportable, and were therefore
loaded into the data mart. Each service query subject contains all fields in all dictionaries used in
the service, provided that the number of fields allowed per service is not exceeded; if so, the
dictionaries and fields are omitted from the service. The service query subjects are not, strictly
speaking, dimensions; they should not be combined with a fact for reporting purposes. Instead, using
a service query subject as your report object provides a shortcut to reporting on all dictionaries and
fields in the service.
• The Service Bundles folder contains all the service bundles and the child services which were
associated to service bundles. These dimensions cannot be joined with any facts or dimensions
which are available in the package.
You generally use the dimensions in conjunction with a fact table, to include additional data about the
fact in your query or report, or to filter the output of the query or report by detailed criteria.
Facts and Star Schemas
Requisitions – ServiceRequestFact
The ServiceRequest fact holds data related to requisition and the requested services. The date and
duration attributes that are included in the fact are for the service request and not for the requisition (a
shopping cart that can contain multiple requests). This fact includes metrics about the
performance—whether the request was in compliance with its SLA, for example, or its actual or
estimated duration, as well as links to all dimensional information about the request, including its
initiator, the customer and any reportable dictionaries included in the service ordered.
A star schema diagram showing the ServiceRequest fact and related dimensions is shown below.