Technical References

1-57
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Chapter 1 Advanced Reporting Data Mart
Data Mart Administration
Dynamically Defined Dimensions
The nature and number of the dictionaries and their attributes which are added to the Custom Reports
Package is dynamically determined and may differ greatly at each Service Catalog installation. To
support the required flexibility, the database which supports the Custom Reports Package includes a set
of abstract data structures, which hold the dimensional data corresponding to the dictionaries, their
attributes, and service configuration using dictionary (form) data. Dictionary contents are mapped to
these tables via the DM_FDR metadata tables explained above.
DM_FDR_DICTIONARYTABLE_n
A set of tables captures attributes (fields) for each reportable dictionary in the application. The number
of these tables is configurable as part of the application installation, as well as the number of columns
of each data type (character, numeric, or datetime).
Each table has the name DM_FDR_DICTIONARYTABLE (or alternate pattern supplied via the
installation procedure), followed by a numeric suffix, _n. Each table is numbered sequentially, starting
with 1. Each instance of this table represents a reportable dictionary.
The DM_FDR_DICTIONARYTABLEs appear in the reporting tools as a set of dimensions within the
DictionaryData folder. The name of each dimension is the caption of the corresponding dictionary. (For
dictionaries with no caption, the dictionary name is used.) The attributes of the dimension are the fields
which comprise the dictionary. The fields are numbered sequentially, starting with 1. The number of each
type of field (character, numeric, or datetime) is specified via the application installation procedure.
DestinationTableName Varchar(200) Table name where the service information is
stored
ServiceAttributeName Varchar(100) Name of the attribute in the service
ServiceAttributeLabel Varchar(200) Caption of the attribute in the service
ServiceAttributeType Varchar(100) Attribute type
ServiceAttributeID Integer Identifier for the attribute of the service
ServiceID Integer Service ID
ServiceName Varchar(200) Name of the service
Column Name Data Type Description
DictionaryID Integer Dictionary ID
RequisitionID Integer Requisition ID
RequisitionEntryID Integer Requisition Entry ID
Field1 through Fieldn Varchar(200) Varchar fields to hold dictionary data
Fieldn+1 through n+m Numeric Numeric fields to hold dictionary data
Fieldn+m+1 through .. Datetime Datetime fields to hold dictionary data