Technical References

1-60
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Chapter 1 Advanced Reporting Data Mart
Data Mart Administration
The tables which comprise the data mart have been indexed to optimize the performance of queries and
reports that retrieve data from multiple query subjects. Because of the dynamic nature of the dictionary
and service-based dimensions, no additional indexes have been added to these tables.
The indexes provided in the statically defined fact and dimension tables are summarized below.
Relationships between the Facts and Dimensions
Requisitions (ServiceRequestFact) are joined to all relevant dimensions (shown in the star schema
previously included) via “inner joins”. That means that any attempt to use query items from both the
requisition and a dimension will show only those requisitions which have a corresponding row in the
dimension. This is generally not a factor for all of the statically defined dimensions, since these are
always required for all requisitions. For example, by definition a requisition must have a customer and
initiator as well as a requested service and all dates associated with the delivery of that requisition.
This does have implications for writing reports. For example, if you start defining a report by choosing
a set of customers, then add requisition data filtered for a particular period, those customers who did not
order a service in that period will “vanish” from the report.
Data Mart Table/View Primary Key Additional Indexes
DM_DEFSERVICE ServiceID SERVICENAME
DM_DEFDICTIONARY DictionaryID DICTIONARYNAME
DM_PERSON PersonID PERSONFIRSTNAME
PERSONLASTNAME
ISQUEUE
DM_DATE DateID (none)
DM_REQUISITIONENTRYFACT RequisitionEntryID SERVICEID
REQUESTORID
CUSTOMERID
STARTEDDATE
CLOSEDDATE
DUEDATE
DM_SERVICETASKFACT ServiceTaskID REQUISITIONENTRYID
PERFORMERID
SERVICEID
STARTEDDATE
COMPLETEDDATE
DUEDATE
QUEUEID
DM_REQUISITONTASKFACT RequisitionTaskID PERFORMERID
STARTEDDATE
COMPLETEDDATE
DUEDATE
QUEUEID