Technical References

1-55
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Chapter 1 Advanced Reporting Data Mart
Data Mart Administration
DM_FDR_DICTIONARYMETADATA
The DM_FDR_DICTIONARYMETADATA table maps individual dictionary fields (attributes)
(identified by DictionaryID and DictionaryAttributeName) to specific columns of the dictionary tables.
For example, the attribute “LastName” in the dictionary RC_REQUESTEDBY may be mapped to (that
is, actually stored in) the data mart table DM_FDR_DICTIONARYTABLE_10, in the field “Field2”.
DM_FDR_ETLMETADATA
The DM_FDR_ETLMETADATA table holds information on configuring the Custom Reports Package
that was specified when the Reporting options was installed, as well as data about the data extraction
process (ETL) and last update information to for scheduled run of the ETL Process.
DictionaryTableName Varchar(50) Name of the data mart table where the
dictionary data is stored
LastDictionaryDateField Integer Last datetime type field used in the dictionary
table
LastDictionaryNumericField Integer Last numeric type field used in the dictionary
table
LastDictionaryVarcharField Integer Last character type field used in the dictionary
table
Column Name Data Type Description
DestinationColumnName Varchar(100) Column name of the table where this attribute
is stored
DestinationTableName Varchar(200) Table name where the dictionary information
is stored
DictionaryAttributeName Varchar(100) Name of the attribute in the dictionary
DictionaryAttributeType Varchar(100) Data type of the attribute in the dictionary
DictionaryID Integer Dictionary ID
DictionaryName Varchar(200) Dictionary name
DictionaryAttributeID Integer Dictionary attribute ID
Column Name Data Type Description
DictionaryTablePattern Varchar(50) Pattern for the name of the dictionary tables; by
default DM_FDR_DICTIONARY_; specified
via Advanced Reporting installation.
Dictionary tables will have the specified name
followed by a number.
Field Pattern Varchar(50) Field pattern for both dictionary and service
tables; by default FIELD_.
LastDictionaryTableSequence Integer Sequence number of the last dictionary table
currently used in the data mart.
LastDictRequisitionID Integer Last requisition ID for which data was written
to the dictionary table.