Technical References

1-21
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Chapter 1 Advanced Reporting Data Mart
Advanced Reporting Module
When creating a report or query, always use the Fact table whose contents best match the type of tasks
to be included in the report. Fact table contents are summarized in the table below.
The same dimensions are related all task-based facts with the exception of the “Service”, which is not
relevant to RequisitionTask facts. A star schema diagram showing the relationships is shown below.
Figure 1-2 Task-BASED Star Schema Diagram
The ServiceTaskFact and RequisitionTaskFact facts have been deprecated. It is recommended that report
designers use other facts to build all custom reports.
Effort Expenditure – TaskEffortEntry Fact
The TaskEffortEntry Fact holds data related the effort expended for each task. Effort entry is available
by category, such as labor or material. Since some implementations have opted to not require effort entry,
there may be no data available for this fact.
Financial
Authorization
Department
Authorization
Department
Review
Service Group
Authorization
Service Group
Review
Delivery
Tasks
Ad-Hoc
Tasks
All Tasks XXXX X XX
Authorization Tasks XXXX X
Delivery Tasks XX
ServiceTask Fact XXXX
RequisitionTask Fact XXX
ĂůĞŶĚĂƌƵĞĂƚĞ
ĂůĞŶĚĂƌ^ƚĂƌƚĂƚĞ
ĂůĞŶĚĂƌůŽƐĞĚĂƚĞ
YƵĞƵĞZĞƋƵĞƐƚŽƌ
^ĞƌǀŝĐĞ

dĂƐŬdLJƉĞ

ŝĐƚŝŽŶĂƌLJϭ
ŝĐƚŝŽŶĂƌLJϮ
ŝĐƚŝŽŶĂƌLJϯ
ŝĐƚŝŽŶĂƌLJ͘͘Ŷ
ZĞƋƵŝƐŝƚŝŽŶdĂƐŬ&ĂĐƚ