In new BI APPS 18.104.22.168.1, the OOB tools (BI Application configuration Manager and Functional setup manager) are really helpful in terms of populating the Domain values automatically. And also it will provide a clear checklist of tasks that should be completed before doing a load. This is really an outstanding work from oracle to minimize the dependency on documentation to configure the BI Apps.
I have outlined the high-level steps to perform a BI Apps 22.214.171.124 Full load into warehouse.
In BIACM (BI Application Configuration Manager): Login to biacm (http://<hostname>:<port>/biacm) and follow these instructions:
Configure the Source System Connection Pool by choosing your Source Product Line and Version.
Select the offerings e.g. Oracle Project Analytics/ Finance Analytics/ etc…
Click on “Perform Functional Configurations” under Functional Configuration Task list and configure the Offerings in Functional Setup Manager (FSM). Here the FSM will provide us a checklist of the tasks we need to do like the list of parameters and other functional settings that we need to setup for a load.
And come back to biacm application and click on “Manage Load Plans” under “Load Plans” Tasks list to create the Load Plans. In BI APPS 126.96.36.199.1, we have a provision to separate the Loads into mini batch loads to minimize the applications/database downtimes. Generally, we will create one Domain Load Plan (SDE, SIL) and one Source Extract and Load (SDE, SIL and PLP). But it’s all depends on the Load strategy we define and will create different set of Load plans like SDE, SIL and PLP.
Domain Load Plan (SDE, SIL): which does extracting the data from Source system and populate the configuration files to load data into
Source Extract and Load (SDE, SIL and PLP):
- Once we created the load plans, save them and generate the Load Plan details. Now click on Execute button to kick off the Load.
Once the Load plan is started, you can monitor the load with tasks by tasks status in ODI Console/ODI Studio. I would prefer the ODI studio as best practice to use to monitor the loads and troubleshooting the issues.
In ODI Studio:
After Load Plan started, Login to ODI Studio with biapps admin username and password, and navigate to Operator, to monitor the load plan with the steps (tasks) those are configured either in sequential or Parallel order for execution. Here you can see the overall Load Plan status by Tasks and also the summary of tasks execution to know how many are in the state of Done/Error/Running/Waiting etc..
We will troubleshoot the failed tasks and after issue fixes we have the ability to start that particular task individually. If any failed task ran successfully after fixes, The ODI will resume the load plan automatically to start next dependent (serial) tasks. Otherwise, we can also resume the Load plan with its “restart from the failure” option.
And also if we feel if the failed task is not a potential failure for the load, then we can “Mark as complete” it like DAC.
Upon Load Plan is successful, the ODI will load data into Warehouse and frees up the work tables where it was doing the transformations.
A sample Screen Shot of BI APPS 188.8.131.52.1 Oracle Project Analytics Dashboard after a full load using ODI 11g:
Have a great time folks…