Technical References

1-25
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Chapter 1 Advanced Reporting Data Mart
Advanced Reporting Module
Service
The service dimension includes a hierarchy (service team, service group, service) for organizing data
relating to the service for which a requisition was ordered or a task was performed. Service attributes
can be used in conjunction with any fact table to qualify or filter the fact data.
Service Bundles
The Service Bundles query subject provides access to all Service Bundles in the application repository.
Supervisor Full Name Full name of the supervisor, in First Name Last Name format
Req_SupervisorFirstName First name of the supervisor
Req_SupervisorLastName Last name of the requestor's supervisor
Req_SupervisorEmail Email address of the requestor's supervisor
Req_SupervisorLoginName Login name of the requestor's supervisor
Query Item Description
ServiceID Service ID
ServiceName Name of the service
Description Brief description for the service
ServiceGroupID ID of the service group to which the service belongs
ServiceGroupName Name of the service group to which the service belongs
ServiceTeamID ID for the service team responsible for the service
ServiceTeamName Name of the service team responsible for the service
ServiceStandardDuration Standard duration specified in the service definition
ServiceDurationUnits Units in which the standard duration is displayed
ServiceHoursPerBusDay Number of hours per business day
EstimatedCost Estimated cost for the service
PublicationDate Publication date for the service
ExpirationDate Expiration date for the service
IsInactive Flag that indicates whether the service is active (0) or inactive (1)
Is Reportable Flag that indicates whether the service is designated as reportable (1) or
not (0). Reportable services will have corresponding query subjects
under the “ServiceData” folder
Is Orderable Flag that indicates whether the service is designated as orderable (1) or
not (0)
Price Service Summary Price
Query Item Description
Service Bundle ID Unique identifier for the service bundle
Service Bundle Name Name of the service bundle
Description Brief description of service bundle