Technical References

1-44
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Chapter 1 Advanced Reporting Data Mart
Key Performance Indicators (KPIs)
Changing field types
The data type of the field (for example, number, date, or character) should not be changed. When the
dimension corresponding to the dictionary is first created, all of the dictionary fields are mapped to
columns of the appropriate data type. This mapping cannot be changed.
A possible approach is to create a new field in the same dictionary of the appropriate type and potentially
delete the old field. Reports needing data from both pre- and post-change would need to include both
fields.
There are no restrictions on changing the HTML representation (display type) for a field. For example,
a text field initially displayed as a set of check boxes could be displayed as a drop-down list with no
effects on the data mart.
Changing field lengths
Changing the length of a numeric field is accommodated by the data mart. Any possible side effects are
minimal. For example, a format previously assigned to an item in a report may have to be adjusted to
accommodate the newly allowed field values.
Changing the length of a text field has minimal effects. If the length were increased to exceed the number
of characters allotted to text fields in the data mart (by default, 200), truncation of the data in the field
would occur. If a text field were shortened, a possible side effect might be that users abbreviate or
otherwise shorten values previously entered in a different format. If a report or query were designed with
a group or section heading based on that field, rows might not be grouped as expected.
Specifying field captions
When a dictionary is added to an active form component, service designers can specify a caption for each
field in a dictionary in the active form component. These captions appear as the field label on the service
form. Service Designer does not enforce a uniqueness constraint on the field captions, since this is
allowed within Service Catalog service forms. However, the same caption should not be used for more
than one field in the same dictionary if the service is to be reportable. This would result in two query
items with the same name, which is not supported.
Deleting a Child Service from a Service Bundle
The business view of the data mart is unchanged—that is, the fields of child service will continue to
appear as query items in the query subject corresponding to the Service Bundle. However, the ETL
Key Performance Indicators (KPIs)
Key Performance Indicators (KPIs) provide a quick, handy way to trace trends or statistics that are
deemed critical to managing Service Catalog services.
Dashboards
The Dashboard option is part of the Reporting module. It allows you to configure the portal to display
up to four KPIs.
Choose Reporting > Dashboard > Configure Dashboard button to display a list of available KPIs.