Cognos data model for replicating data

To help you manage a replicated database that can be used to run the Cognos® reports and dashboards, CDC Replication scripts are provided. If you don't want to use these CDC Replication scripts, you can use your own replication tools to manage the replicated database. The following information is needed to set up your own replication.

The archive file names, package names, dashboard names, and data sources for the Common Services Cognos sample dashboards are shown in the following table.

Cognos archive file name Cognos package name Dashboard names Data source name Data source type
PFS_Dashboards.zip pkg_pfs_dashboard
  • System management dashboard
  • System management performance dashboard
 pfs_dashboard_source DQM
PFS_Trending_Dashboards.zip pkg_pfs_trending_dashboard
  • Inbound transaction volume trends dashboard
  • Inbound transmission volume trends dashboard
  • Outbound transaction volume trends dashboard
  • Outbound transmission volume trends dashboard
  • Return trends dashboard
  • System alert trends dashboard
 pfs_trending_dashboard_source DQM

To run the Cognos dashboards and reports against a replicated database, it must have all of the views and tables that are used by the dashboards and reports. Your custom replication scripts need to replicate the data from the database tables and views that are shown in the following table.

Cognos package name Database public views Database tables to replicate
pkg_pfs_dashboard
ALERTS_V
BASIC_INBOUND_BATCH_DATA
BASIC_PARTNER_V
BUSINESS_DAY_VIEW
CORE_PROPERTIES_DATA
GW_FILE_STAT_V
IN_REQ_CORREL_PFS_V
INBOUND_CASHLETTER_DATA
INBOUND_TRANSMISSION_DATA
OUT_PRES_GROUP_PARTICIPANT_V
OUT_REQ_CORREL_PFS_V
OUTBOUND_PRES_PART_VIEW
PAYMENT_DATA
PROCESSING_WINDOW_V
REASON_CODES_V
TRANSACTION_RPT_V
TRANSMISSION_RPT_V
APP_VERSION
APPLICATION
ALERT
ALERT_NOTES
APP_LOG
BANK
BUSINESS_DAY
CASH_LETTER
CHANNEL
CHANNEL_DEF
CLASSIFICATION
CORE_PROPERTIES
DEPOSITOR_PRODUCTS
FILE
FILE_DEF
FILE_TYPE
GW_FILE_STAT
IN_REQ_CORREL
ITEM
OBJ_BASE
OBJ_VALUE
OUT_REQ_CORREL
OUTBOUND_PRES_GROUP
OUTBOUND_PRESENTMENT
PARTNER_GENERAL
PAYMENT
PAYMENT_MESSAGE_TYPE
PAYMENT_STANDARD_TYPE
PRES_PRES_XREF
PRESENTMENT
PRESENTMENT_GROUP
PRESENTMENT_TYPE
PROCESSING_WINDOW
PROCESSING_WINDOW_ACTIVITY
PRODUCT_INSTANCE
REASON_CODES
ROUTING_MODE_TYPE
TRANSACTION_BASE
TRANSMISSION_BASE
TXN_PAYMENT_BASE
pkg_pfs_trending_dashboard
ALERTS_V
BASIC_INBOUND_BATCH_DATA
BASIC_PARTNER_V
BUSINESS_DAY_VIEW
CORE_PROPERTIES_DATA
GW_FILE_STAT_V
INBOUND_CASHLETTER_DATA
INBOUND_TRANSMISSION_DATA
OUT_PRES_GROUP_PARTICIPANT_V
OUTBOUND_PRES_PART_VIEW
PAYMENT_DATA
PROCESSING_WINDOW_V
REASON_CODES_V
ALERT
ALERT_NOTES
APP_LOG
BANK
BUSINESS_DAY
CASH_LETTER
CHANNEL
CHANNEL_DEF
CORE_PROPERTIES
DEPOSITOR_PRODUCTS
FILE
FILE_DEF
FILE_TYPE
GW_FILE_STAT
ITEM
OUTBOUND_PRES_GROUP
OUTBOUND_PRESENTMENT
PARTNER_GENERAL
PAYMENT
PAYMENT_MESSAGE_TYPE
PAYMENT_STANDARD_TYPE
PRES_PRES_XREF
PRESENTMENT
PRESENTMENT_GROUP
PRESENTMENT_TYPE
PROCESSING_WINDOW
PROCESSING_WINDOW_ACTIVITY
PRODUCT_INSTANCE
REASON_CODES
ROUTING_MODE_TYPE
TRANSMISSION_BASE