Technical References

1-61
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Chapter 1 Advanced Reporting Data Mart
Data Mart Administration
It is critically important for the dynamically defined, dictionary-based dimensions. If a dictionary was
not used in a particular service, any requisitions for that service will not appear on a report that includes
query items from that dictionary-based dimension.
Similarly, for delivery tasks (ServiceTaskFact) and service-level authorizations (RequisitionTaskFact),
inner joins relate the fact to all dimension tables except the queue. These facts are joined to the Queue
dimension via an “outer join”, which supports optional relationships. This allows the service designer to
assign the task to a specific person or functional position, rather than to a queue. If a task was not
assigned to a queue, it still appears on the report, but the queue will be blank.
For request-level authorizations (AuthTaskFact), too, the queue is optional. In addition, the service is not
relevant, since the authorization is performed at the request level, rather than for any individual services
which comprise the request.
Relationships in Organizational Data
The Organizations folder allows you to compose reports on people, organizations, and groups. Service
Catalog supports many-to-many relationships between these entities. For example, a person may be a
member of many organizations (a business unit and multiple service teams); an organization comprises
many people. These relationships are reflected in the data mart design, so you can combine two of these
entities on a report and group by either entity. For example, you could report on all organizations, listing
their members; or you could choose a person, and list all the organizations to which that person belongs.
Fact to Fact Relationships
Refreshing theStandard Reports Package
All tables in the reporting database that support the Standard Reports Package are truncated and
completely refreshed in every ETL cycle. Report contents are refreshed and available for viewing as soon
as the ETL cycle has completed. The prebuilt reports cannot be run while the ETL is in process.
Refreshing the Data Mart
Several Cognos and Service Catalog components are required to refresh the database contents of the
Custom Reports Package, which provides the business view of the data mart.
Fact-1 Fact-2 Type of Relationship
ServiceRequestFact ServiceTaskFact Left Outer Join
ServiceRequestFact DeliveryTaskFact Inner Join
ServiceRequestFact AuthTaskFact Left Outer Join
ServiceRequestFact AllTaskFact Left Outer Join
AllTaskFact TaskEffortEntryFact Left Outer Join
DeliveryTaskFact TaskEffortEntryFact Left Outer Join
ServiceTaskFact TaskEffortEntryFact Left Outer Join