Please provide a listing of the tables involved in WCC/AutoSys reporting.

Document ID : KB000050752
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Please provide a listing of the tables involved in WCC/AutoSys reporting.

Solution:

The AutoSys autoaggar reads from the table named ujo_proc_event within the MDB database.

It then populates the statistics in 4 additional tables in the MDB based on the options given to autoaggr:

   TABLE_NAME   
   ------------------------------   
   UJO_REP_DAILY   
   UJO_REP_HOURLY   
   UJO_REP_MONTHLY   
   UJO_REP_WEEKLY  

The WCC Collectors extract the data from the AutoSys or CA7 databases (ujo_rep* tables) and load their data into the following tables:

   TABLE_NAMES   
   ------------------------------   
   DATE_DIMENSION   
   TIME_DIMENSION   
   SERVER_DIMENSION   
   AS_MACHINE_DIMENSION   
   AS_STATUS_DIMENSION   
   AS_EVENT_DIMENSION   
   AS_JOB_DESC_DIMENSION   
   AS_JOB_DEF_DIMENSION   
   AS_JOB_OWNER_DIMENSION   
   AS_JOB_RUN_FACT   
   AS_JOB_RUN_STAGE   
   AS_JOB_RUN_EVENT_FACT   
   AS_JOB_RUN_EVENT_STAGE   
   AS_STATISTIC_FACT   
   AS_STATISTIC_STAGE   
   CA7_EVENT_DIMENSION   
   CA7_STATUS_DIMENSION   
   CA7_JOB_DEF_DIMENSION   
   CA7_JOB_RUN_FACT   
   CA7_JOB_RUN_STAGE   
   CA7_JOB_RUN_EVENT_FACT   
   CA7_JOB_RUN_EVENT_STAGE   
   CA7_STATISTIC_FACT   
   CA7_STATISTIC_STAGE  

Business Objects has its own set of tables as well

   Tables    
   ------------------   
   CMS_Aliases5   
   CMS_CCFrontier5   
   CMS_Frontier5   
   CMS_IdNumbers5   
   CMS_InfoObjects5   
   CMS_RELATIONS5   
   CMS_RFrontier5   
   CMS_VersionInfo