Technical References

1-31
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Chapter 1 Advanced Reporting Data Mart
Advanced Reporting Module
Organizations Folder
The Organizations folder contains query subjects which allow you to report on organizations, groups,
people, and the relationships among these entities. These query subjects cannot be joined to the
transactional (fact) data. Instead, you should use the organization or person information in the
appropriate dimension—Customer, Performer, or Requestor—to include such items in reports that also
include data on tasks or service requests.
Group
Groups provide a container for disparate sets of people or organizations, allowing you to assign
permissions or tasks to a single group rather than to the individual group members. To view members of
a group, or see the groups with which a person was affiliated, a report could contain items from the
Group and Person query subjects.
Person
The Person query subjects provides access to all people in the repository, regardless of the role
(Customer, Performer, Requestor) they have played in the processing of service requests.
Category The category in which the effort was expended
ContributorID Person ID of the person who performed the task for which effort entry was
required
Contributor Full Name Full name of the contributor in First Name Last Name format
ContributorFirstName First name of the person who performed the task for which effort entry was
required
ContributorLastName Last name of the person who performed the task for which effort entry was
required
EffortQuantity Number of units of effort expended
EffortCost Total (extended) cost of the effort entry – unit cost multiplied by quantity
EffortUnitCost Unit cost of each unit of effort
UnitType The unit of measure for the effort entry
Query Item Description
Query Item Description
Group Name Name of the group
Group Status Status of the group – Active or Inactive
Parent Group Name Parent of the group
Description Description of the group
Query Item Description
Person ID ID of the person who requested the service
Person Full Name Full name of the person, in First Name Last Name format
First Name First name of the person