Technical References

1-54
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Chapter 1 Advanced Reporting Data Mart
Data Mart Administration
Service-Form Reporting Metadata
The data mart ETL processes use a set of tables in the data mart database to configure the ServiceData
and DictionaryData dimensions that are exposed to users in the Ad-Hoc Reports and Report Designer
options. These tables are created when the Custom Reports Package is installed and populated when data
is loaded into the data mart.
These metadata tables are not exposed in the Cognos framework. The contents of these tables are used
to specify the dynamically defined dictionary and service-based dimensions which appear as the
business view of the data in the Custom Reports Project.
These tables are described below. The description for each column uses an abstract data type; the actual
data types will vary, depending on the database (Oracle or SQLServer) in which the data mart resides.
DM_FDR_ETLDICTIONARYMETADATA
The DM_FDR_ETLDICTIONARYMETADATA table maps a particular reportable dictionary (identified
by its DictionaryID) to the DM_FDR_DICTIONARY_n table in which dictionary data is stored
(DictionaryTableName). It also tracks how many date, numeric, and varchar fields are used within that
dictionary and consequently, within the corresponding data mart table.
Customer
Requestor
Performer
Person
Queue
DirPerson
DirOrganizationalUnit
DirNetworkInfo
DirLocation
DirAddress
ServiceRequestFact TxRequistionEntry
TxRequisition
ServiceTaskFact TxRequisitionEntry
TxActivity
RequisitionTaskFact TxRequisition
TxActivity
TaskEffortEntryFact TxBilling
DefExpenditureType
DefBillingClass
DefUnitType
DirOrganizationalUnit
DirPerson
Data Mart Query Subject OLTP Database Tables
Column Name Data Type Description
DictionaryID Integer Unique identifier for the dictionary