Technical References

1-51
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Chapter 1 Advanced Reporting Data Mart
Data Mart Administration
This report is essentially a pivot report. The metric that is pivoted is the “age” of the open task. To
produce this report:
• Place the appropriate attributes/dimensions on the report work area—the queue organization; the
queue name; and the task name for the Delivery Tasks fact.
• Compute the age of the task by taking the difference (in days) between the current date and the task
due date.
• Set up a custom group for the four aging buckets.
• Pivot the report using the custom group (Age) as the metric.
Service Volumes and Activity
The Service Volumes and Activity reports give summary information on the number of services requests
started within a particular time frame, and the current status of those requests. For example, the Service
Volume: Request Activity by Service looks like this:
Because of the complexity of the computations (tallying up the counts based on the status of the request),
this report needs to be implemented in Report Designer.
Data Mart Administration
This section is intended for use by people who need to know technical implementation details of the
Service Catalog reporting solution. These include report administrators, responsible for the reporting
environment; support personnel who may need to report issues to Cisco TAC; and analysts and designers
who want to investigate the options of customizing or enhancing components of the reporting options.
Role-Based Access
Service Catalog provides role-based access to all reporting capabilities. User profiles are directly
accessed in the database via the Service Catalog namespace.