Time Dimension Implementation Notes

• As this is the first time that whs objects will be created in designer, create an Application System Context Container:
• Open Designer - Entity Relationship Diagrammer.
• File -> New
• Choose Container:
• Click [List-of-Values].
• [Create]
• Select Type:
• -Application Systems-
• [OK]
• Select Object:
• Change the name of the newly created icon to whs.
• [OK]
• Choose Container:
• -whs-
• [OK]
• The container is created and a diagrammer window displayed. There is no diagram at this stage so the Entity Relationship Diagrammer can be closed.
• Open Design Editor - Server Model. The new container should be listed.
  
• Open Design Editor - Server Model - whs and create and generate the following objects to whs@whs:
• D_TIME_S
• Move the following code to the whs code directory:
• cre_tob_d_time.sql
• cre_tta_d_time.sql
• dro_tob_d_time.sql
• dro_tta_d_time.sql
• rec_tta_d_time.sql
• f_d_time.sql
  
• Start OWB:
• I need a DB Link between whs and ctl so that my table function can access the PL/SQL library housed on ctl:
• Create an Oracle Module for whs as a Warehouse Target creating a location name WHS_TGT.WHS as the Connection and WHS_TGT as the Location.
• Create a Connector from whs to ctl named WHS_CTL.
• The Connector needs to be deployed to whs before it can be used and before that can happen, a Runtime Repository Connection needs to be created:
• Create a Runtime Repository Connection to the repository on whs named WHS_RTM.
  
• As dwmgr, start sqlplus as whs@whs and run the following scripts:
  
• rec_tta_d_time.sql
• Ignore the errors associated with the DROP statements.
• f_d_time.sql
  
• Note: This will create the function and then run a short test where it selects a few days from the function.
  
• Define the Dimension in OWB:
• Open OWB.
• Create A Dimension D_TIME base on the Definition.
• Create the Mapping in OWB:
• Open OWB.
• Create A Mapping M_W2W_D_TIME based on the Definition.
• Create the Process Flow in OWB:
• Open OWB:
• Create a Wrapper Process Flow - PF_D_TIME for M_W2W_D_TIME based on the Definition.
• Create the shell wrapper script:
• run_PF_D_TIME.sh