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

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

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