You are browsing the archive for Concurrent Requests & Reports.

Estimate Warehouse Size

 

NAME: Estimate Warehouse Size
SHORT CODE: EDW_SIZE_WRAPPER
MODULE: Oracle Application BIS

Description: Estimate EDW Size
Navigation: Oracle Application BIS Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • table_logical_name : Logical name of object
  • from_date : From Date
  • to_date : To Date
  • num_of_rows : Number of rows
  • avg_row_len_custom : Average row length of customized columns
  • loader_commit_size : Commit size of loader

 

Generate Warehouse Size Report

 

NAME: Generate Warehouse Size Report
SHORT CODE: EDW_SIZE_REPORT
MODULE: Oracle Application BIS

Description: Generate Warehouse Size Report
Navigation: Oracle Application BIS Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • object_logical_name :

 

Remove EDW Security Policy from Fact

 

NAME: Remove EDW Security Policy from Fact
SHORT CODE: EDW_REMOVE_POLICY
MODULE: Oracle Application BIS

Description: Remove EDW Security Policy from Fact
Navigation: Oracle Application BIS Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • fact_table_name : fact_table_name