1. User Guide
  2. How to Change the Product Dimension in ALM BI
  3. Changing the Product Dimension - Overview

10.1 Changing the Product Dimension - Overview

ALM Product is a logical idea in the Presentation or Logical layer. In the physical layer, it can hold any one of the Product Dimension members that are available in ALM.

(This can be DIM_COMMON_COA, DIM_PRODUCT, DIM_GL_ACCOUNT, or any other user-defined Product Dimensions).

As part of the released RPD (ALMBI 6.1 version), the ALM Product container was mapped to the DIM_PRODUCT table in the physical layer (containing PRODUCT_ID). In an implementation, however, users can point to any other Product Dimension table.

The section Steps to Point to a Different Product Dimension in ALMBI describes the steps to change the Product Dimension in the following three cases:

  • Case 1: Changing the Product Dimension from DIM_PRODUCT to DIM_COMMON_COA.
  • Case 2: Changing the Product Dimension from DIM_COMMON_COA to DIM_GL_ACCOUNT.
  • Case 3: Changing the Product Dimension from DIM_PRODUCT to the user-defined dimension. For example: DIM_TM_COA_ID.