Technical References

Contents
iv
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Key Performance Indicators (KPIs) 1-44
Dashboards 1-44
KPI Administration 1-45
Metrics and Attributes 1-45
Metrics 1-45
Measures of Service Volume: Who is the Customer? 1-46
Measures of Task Delivery Performance 1-46
Attributes 1-47
Standard Reports Design 1-48
People, Roles and Groups 1-48
Service Design Details 1-49
Request Management 1-50
Service Volumes and Activity 1-51
Data Mart Administration 1-51
Role-Based Access 1-51
Data Mart Source Data 1-53
Service-Form Reporting Metadata 1-54
Dynamically Defined Dimensions 1-57
Data Mart Database Objects 1-59
Refreshing theStandard Reports Package 1-61
Refreshing the Data Mart 1-61
Process Flow for the Custom Reports Package 1-62
Customizing the Data Mart 1-64
CHAPTER 2 Data Mart Schema 2-1
Custom Reporting Data Model 2-1
Data Mart Schema Design and the Business View 2-1
Star Schema Design for AllTaskFact (All Tasks) 2-2
Star Schema Design for AuthTaskFact (Authorization Tasks) 2-3
Star Schema Design for DeliveryTaskFact (Delivery Tasks) 2-4
Star Schema Design for ServiceRequestFact (Requisitions) 2-5
Dictionary and Service-Based Dimensions 2-5
I NDEX