Technical References

1-53
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Chapter 1 Advanced Reporting Data Mart
Data Mart Administration
Data Mart Source Data
The accuracy and completeness of the data in the data mart is critical. In order to gauge these qualities,
it is critical for the source of the data in the data mart to be documented. The table below shows the tables
in the OLTP database which contributed to data found in the query subjects available in the Custom Data
Mart.
Analytics
Administrator
• View Request
Center Reports
• Ad-Hoc
Reports
• Report
Designer
• KPI
Administrator
• Report
Administrator
• Ability to view the KPI dashboard and run all reports in
the Reporting module
• Access to Ad-Hoc Reports in the Advanced Reporting
module
• Access to Report Designer in the Advanced Reporting
module
• Ability to manage public Reporting folders, the
dashboard, and Cognos administration
• Access to KPI Administration in the Advanced
Reporting module
Site Administrator
• All • All Service Catalog and Cognos capabilities in the
Reporting and Advanced Reporting modules
Role Capabilities Description
Data Mart Query Subject OLTP Database Tables
Dictionary Data
(user-specific reportable dictionaries)
DefDataDictionary
DefObjectDictionaries
TxRequisitionEntry
Service form Data
(user-specific reportable services)
DefService
DefServiceExtension
DefDataDictionay
DefObjectDictionaries
DefData
TxRequisionEntry
Service DefService
DefArea
DirOrganizationalUnit
Dictionary DefDataDictionary
DefDictionaryGroup
Keyword DefKeyword
Group DirGroup
Organization DirOrganizationalUnit