0 Replies Latest reply: Apr 17, 2013 12:22 PM by 1001800 RSS

    OFSA-ALMBI: How to execute SCD Process unused Batch Processing Framework

    1001800
      The following steps comprise the ALM BI Process:
           +1. Hierarchy Flattening+
           +2. Dimension Table Population and Slowly Changing Dimension Processing+
           +3. Populating the Dimension Run table+
           +4. Time Dimension Population+
           +5. ALM Results Transformation+

      I have problem to execute this steps from Batch Processing framework.

      So, I decided to execute this steps with same workaround.

      Step 1:
      I could run this step using SQL Plus/PLSQL
           Function Name: rev_batchHierFlatten
      Parameters: batch_run_id, mis_date, pDimensionId, pHierarchyId
      function rev_batchHierFlatten(batch_run_id varchar2,
      mis_date varchar2,
      pDimensionId varchar2,
      pHierarchyId varchar2,
      +)+

      Step 2:
      I don't know how to execute step 2 without using Batch Processing framework.
      Can anyone help me?

      Thank you in advance.
      Laura