Technical References

1-20
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Chapter 1 Advanced Reporting Data Mart
Advanced Reporting Module
Figure 1-1 Service Request Star Schema Diagram
Task-Based Facts
The Service Catalog data mart provides five views of the task-based facts. Two of these views
(RequisitionTaskFact and ServiceTaskFact) are provided primarily for backward compatibility with
previous versions of Advanced Reporting. They may freely be used; however, they do not contain some
metrics and counts which may be useful for many reports.
Each view is optimized by grouping certain sets of tasks. Reports and queries which need to interrogate
tasks will perform best if they are based on the task-based fact which best meets the report's
requirements.
Task-based facts are summarized below.
ĂůĞŶĚĂƌƵĞĂƚĞ
^ĞƌǀŝĐĞZĞƋƵĞƐƚ&ĂĐƚ
ĂůĞŶĚĂƌ^ƚĂƌƚĂƚĞ
ĂůĞŶĚĂƌůŽƐĞĚĂƚĞ
ƵƐƚŽŵĞƌZĞƋƵĞƐƚŽƌ
^ĞƌǀŝĐĞ
ŝĐƚŝŽŶĂƌLJϭ
ŝĐƚŝŽŶĂƌLJϮ
ŝĐƚŝŽŶĂƌLJϯ
ŝĐƚŝŽŶĂƌLJ͘͘Ŷ

Fact Usage/Description
All Tasks All tasks performed during fulfillment of a service request.
Authorization Tasks All authorization and review tasks.
Delivery Tasks All delivery tasks, including ad-hoc tasks.
RequisitionTask Fact All tasks which are performed at the requisition level and not at each
service task level. These include financial authorizations, departmental
authorizations, and departmental reviews. If sites do not use any of these
authorization types, this fact table is empty. This query subject is
provided primarily for backward compatibility with previous versions of
the Service Catalog data mart.
ServiceTask Fact Data related to service-level tasks. These include service group
authorizations and reviews; service delivery tasks; and ad hoc tasks. This
query subject is provided primarily for backward compatibility with
previous versions of the Service Catalog data mart.