Technical References

1-48

Cisco Prime Service Catalog 10.0 Reporting Guide

OL-31037-01

Chapter 1 Advanced Reporting Data Mart

Standard Reports Design

The Standard Reports Package contains denormalized base data tables. These tables are used as the basis

for the prebuilt reports as well as providing summary data tables for populating the KPIs.

Each of these tables is a standalone entity—it is not possible to join a table to any other in order to create

a new report or modify an existing report. If you need to make modifications to a standard report, your

best bet is to construct the desired report from scratch, using the Service Catalog data mart and the

Custom Reports package. This section gives some hints on how to do this for some of the reports, using

Ad-Hoc Queries (Query Studio) to construct the query.

People, Roles and Groups

The reports in the People, Roles, and Groups folder can be duplicated by using the query subjects in the

Organizations folder (Person, Group, and Organizational Unit) and the Queue dimension. The reports

are fairly straightforward and can be generated by inserting the appropriate items on the report and

grouping as desired.

For example, the Organizational Units by People report might look like this:

The report definition (viewable under Manage File in Query Studio) to build this report would look like

the following figure (with a group specified on the Person Full Name, and the filter defined as a “Search

and Select” filter).

Billed* The organization which is billed for the service. This is the same as the

customer for the service unless a different organization is chosen as the Bill

To: Customer when the ordered is reviewed (after a request has been saved,

but before it has been submitted.) Only an organizational unit that has been

designated as Billable can be chosen as the Bill To: Customer.

Performer* The person (and corresponding home OU) who performed the task. See the

“Measuring the performance of individuals” section on page 1-46 for more

information.