You are browsing the archive for Concurrent Requests & Reports.

Analyze Fact

 

NAME: Analyze Fact
SHORT CODE: EDW_ANALYZE_FACT
MODULE: Oracle Application BIS

Description: Analyzes a fact. If no parameter is specified, analyzes all facts
Navigation: Oracle Application BIS Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_fact_name : Fact name. if null, all facts are analyzed
  • p_mode : 0 means analyze only fact table. 1 means analyze only fact interface table

 

Analyze Dimension

 

NAME: Analyze Dimension
SHORT CODE: EDW_ANALYZE_DIMENSION
MODULE: Oracle Application BIS

Description: Analyzes a given dimension. If no parameter is specified, analyzes all dimensions
Navigation: Oracle Application BIS Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_dim_name : Dimension name. If null, all dimensions are analyzed
  • p_mode : 0 means analyze only level and star table. 1 implies analyze only interface tables

 

Add EDW Security Policy to Fact

 

NAME: Add EDW Security Policy to Fact
SHORT CODE: EDW_ADD_POLICY
MODULE: Oracle Application BIS

Description: Add EDW Security Policy to 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