Technical References

2-5
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Chapter 2 Data Mart Schema
Custom Reporting Data Model
Star Schema Design for ServiceRequestFact (Requisitions)
Dictionary and Service-Based Dimensions
The above diagrams are incomplete. All fact tables actually have one-to-many relationships to
dictionary- and service-based dimension tables. For services that do not contain any grid dictionaries,
the relationships are always one-to-one (see the “DM_FDR_SERVICETABLE_n” section on page 1-58
for more information). These relationships are implemented via the column REQUISITIONENTRYID,
which is present in all fact and dimension tables, but is not exposed in the business view's dimensions.
When you create reports using Query Studio or Report Designer with service and task fact tables joined,
the task data may appear to be repetitive due to the one-to-many relationships among these tables. You
may use the grouping feature in the reporting tool to collapse the identical information.
The dictionary- and service-based query subjects which appear in the data mart under the Dictionaries
and Services folders correspond to tables in the physical database named
DM_FDR_DICTIONARYTABLE_n and DM_FDR_SERVICETABLE_n, respectively, where
• n is a sequential number starting with 1, and
• the number of tables of each type is determined by the number specified when the Advanced
Reporting option is configured.