Technical References

1-6
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Chapter 1 Advanced Reporting Data Mart
Reporting Architecture and Components
Service Catalog Data Mart – Advanced Reporting
The Advanced Reporting module allows users to build custom reports and queries from data in the
Service Catalog data mart, capturing data from Service Catalog.
Service Catalog Data Mart
The Service Catalog Data Mart is based on the Custom Reports Data Model package. This package gives
users access to a data mart which includes service, task, requisition and effort-related information, such
as the task performer or the duration of a task. The custom reports package differs from the standard
package in important ways:
• The custom reports package does not include any prebuilt report or KPIs. It is meant strictly for
ad-hoc reports and queries.
• The custom reports package allows access to form-based data, data derived from the dictionaries and
attributes which are displayed and entered on user-configured service forms.
• The custom reports package is organized as a “dimensional model,” a flexible data model with the
relationships among the different types of data, which encourages building ad-hoc reports and
queries. This model is described in detail in the Advanced Reporting Module, page 1-16.
Running Reports
Overview
This section gives basic information on how to run reports, and how to configure the Service Catalog
dashboard to display KPIs. Instructions on running reports apply both to the standard (prebuilt) reports
and any custom reports that were developed using the Advanced Reporting options and published to the
public or private folders.
Accessing Reporting Options
All reporting options are integrated into the Service Catalog menus. The Reporting and Advanced
Reporting options appear on a user's drop-down menu, provided that a permission which grants rights to
execute these options has been granted to the user. Details on role-based access are given in the “Data
Mart Administration” section on page 1-51.
Reporting options are accessible from the Service Catalog menu:
The Reporting menu option provides the following options:
• Reports – the ability to run all prebuilt reports and to modify or copy reports (as appropriate to each
user’s privileges)
• Dashboards – the ability to configure the dashboard displayed by each user’s portal to include
specified KPIs