Technical References

CHAPTER
2-1
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
2
Data Mart Schema
• Custom Reporting Data Model, page 2-1
Custom Reporting Data Model
Data Mart Schema Design and the Business View
The data mart schema was designed to be used with IBM Cognos Framework Manager and the business
view used by the IBM Cognos reporting tools (Query Studio and Report Studio, represented as Ad-Hoc
Reports and Report Designer in the Service Catalog Advanced Reporting module). As such, technical
documentation in the Data Mart chapter outlines the contents and relationships of the query subjects, but
does not cover the underlying data model, which is not exposed to reporting users or designers.
This chapter is meant for technical personnel who wish to investigate the physical data model underlying
the business view exposed via the Cognos tools. In particular, it may be useful to map the names for the
database objects in the diagrams that follow to corresponding names of query subjects. In the following
diagrams:
• The Queue query subject is based on the V_DM_PERSON database view, and is joined to Task
views via the QUEUEID column.
• The Performer query subject is also based on the V_DM_PERSON.PERSONID business view and
is joined with Task views via the PERFORMERID column.
• The Customer and Requestor query subjects (dimensions) are also based on the V_DM_PERSON
database view, and are joined to the Requisition views via the CUSTOMERID and REQUESTORID,
respectively
• All date dimensions (CalendarStartedDate, CalendarDueDate, CalendarClosedDate and
CalendarScheduledDate) are based on the V_DM_DATE business view. They in turn are joined with
the Task and Requisition views by the STARTEDDATEKEY, DUEDATEKEY,
COMPLETEDDATEKEY and SCHEDULEDSTARTDATEKEY respectively.
• All fact tables also include a join (not depicted in the diagrams) to Bundled Service data, available
in V_DM_SERVICEBUNDLE.