Search Results implement_dim_aw

Overview

APPS.BSC_AW_ADAPTER_DIM is a PL/SQL package belonging to the Oracle Balanced Scorecard (BSC) product family, which underpins the analytic workspace (AW) layer in Oracle E-Business Suite. The package serves as an adapter between the EBS data model and the Oracle OLAP analytic workspace, translating dimension definitions maintained in the application tables into the physical AW objects required for multidimensional analysis. Its header declares shared state such as g_debug, g_commands (a cache of AW commands executed as a batch), and g_exception, together with a comprehensive set of record and collection types (dim_parent_child_r, levels_r, zero_levels_r, rec_levels_r) that model dimension hierarchies, level properties, primary keys, seed values, and snowflake relations. The package is classified as OTHER rather than as a public API, indicating it is intended for internal consumption by the BSC schema and its dependents.

Key Procedures and Functions

The package exposes 75 documented procedures and functions. The central entry points are CREATE_DIM and CREATE_DIM_PROGRAM, which build a dimension and generate the AW program that materializes it. CREATE_DIM_PROGRAM_REC handles the recursive variant of program creation. Supporting these are GET_ALL_DIM_LEVELS, which enumerates the levels defined for a dimension, and GROUP_LEVELS_INTO_SETS, which partitions levels into logical sets so that each set maps to a distinct dimension; ASSIGN_SET_TO_LEVEL and SET_LEVEL_POSITION manage that grouping and ordering metadata. CREATE_VIRTUAL_ZERO_CODE_LEVEL and CREATE_VIRTUAL_REC_LEVEL construct the synthetic levels required by recursive dimensions.

Physical object construction is handled by CREATE_DIM_OBJECTS, CREATE_DIM_FOR_LEVELS, CREATE_CCDIM, CREATE_LEVEL_NAME_DIM, and CREATE_RELATION, the last of which emits the parent-child relations between levels. IMPLEMENT_DIM_AW executes the cached AW commands against the analytic workspace. Cleanup and reset operations are provided by DROP_DIM, DROP_OLD_DIM_FOR_LEVEL, DROP_KPI_OBJECTS_FOR_DIM, and RESET_DIMENSION_R. GET_KPI_FOR_DIM resolves the key performance indicators associated with a dimension.

Tables Accessed

The package references DBMS_SQL, used as a dynamic SQL facility for building and executing generated statements and for the varchar2_table type that caches AW commands. BSC_OLAP_OBJECT stores the definitions of OLAP objects, including dimensions and their levels, while BSC_OLAP_OBJECT_RELATION records the relationships between those objects, such as parent-child links and snowflake associations. The APPS synonym PLITBLM (PL/SQL Index-by Table Library) is used for generic collection manipulation during level processing. These four objects constitute the documented data access footprint of the package.

Usage Notes

BSC_AW_ADAPTER_DIM is invoked internally during Balanced Scorecard administration, typically when a user creates or modifies a dimension through the BSC configuration interface and the system must synchronize that definition into the analytic workspace. The package is referenced by 10 other packages, confirming its role as a shared low-level component rather than a directly callable user API. Because of its dependency on AW infrastructure and its use of dynamic SQL, it should not be called directly from custom code; integrators should instead use the documented BSC configuration flows. The relative position of CREATE_DIM_PROGRAM in the procedure inventory makes it the focal routine for searches involving dimension program generation in EBS 12.1.1 and 12.2.2.