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

 

Leave a reply

Your email address will not be published. Required fields are marked *