Technical References

1-22
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Chapter 1 Advanced Reporting Data Mart
Advanced Reporting Module
Organizations
The Organizations folder contains information on the groups, organizations, and people configured at
the site. Query subjects in this folder cannot be joined with dimensional or fact data, but only with each
other. Corresponding query items can be found in query subjects within the Dimensions and Facts
folders.
Data Mart Dimensions
All query items (attributes of both facts and dimensions) available in the Dimensions folder of Custom
Reports package are summarized in the tables in this section. This list does not include any dictionary
or service-based form data, which, of course, will vary from site to site.
Customer
The customer dimension describes the person who is the recipient of the service which was ordered.
The semantics of the query items which comprise this query subject may be modified if custom
mappings to Person attributes have been applied as part of directory integration. The descriptions given
below are the defaults that are expected by Organization Designer. Some of these fields may be blank,
if they are not used at a particular site.
Query Item Description
CustomerID Customer ID
Customer Full Name Full name of the customer, in First Name Last Name format
CustomerFirstName First name of the customer
CustomerLastName Last name of the customer
CustomerOUID Organizational Unit ID of the customer's home OU
CustomerOUName Name of the customer's home organizational unit
CustomerBuilding Building in which the customer is located
CustomerBuildingLevel Building level/floor on which the customer is located
CustomerOffice Office of the customer
CustomerCubic Customer cubicle number
CustomerStreet1 First line of the street address of the customer
CustomerStreet2 Second line of the street address of the customer
CustomerCity City in which the customer is located
CustomerStateProvince State in which the customer is located
CustomerZip Zip code of the customer
CustomerCountry Country in which the customer is located
CustomerLoginName Login name of the customer
CustomerEmailAddress Email address of the customer
Work Phone The work phone of the customer
Cust_SupervisorID ID of the customer's supervisor