Generating Oracle BI Apps 11g Data Load Plans

by Veera Reddy Ramidi

This blog introduces and explains the detailed step by step process for executing the Data Load to Business Analytics Warehouse. Here, we are illustrating for the Student information Analytics data using the new OBIA 11g which is supported only for PeopleSoft 9.0 Campus Solutions.

This blog can be used similarly for any other Analytics using OBIA 11g and continues from my previous post, (OBIA 11g Domain Load to Business Analytics Warehouse).

 

Examining Oracle BI Apps 11g: The Series


 

  • Go to the BI Apps Configuration Manager URL and use the BI Apps Administration Credentials to login, making sure that the managed servers (odi_server1 and bi_server1) are up and running.
  • In the Navigation Panel (on left), click on “Perform Functional Configurations” under “Functional Configurations.” It will navigate to new window.

RamidiVeeraReddy 2013 06 21 GeneratingOBIA11gDataLoadPlan Image 1 resized 600

  • Login to the “Functional Setup Manager” using BI Apps Administrator credentials.
  • In the Navigation Panel (on left), click on “Configure Offerings” under “Implementations.”

RamidiVeeraReddy 2013 06 21 GeneratingOBIA11gDataLoadPlan Image 2 resized 600

  • Expand All Offerings under Oracle Student Information Analytics. And check RamidiVeeraReddy 2013 06 21 GeneratingOBIA11gDataLoadPlan Image 21 resized 600

RamidiVeeraReddy 2013 06 21 GeneratingOBIA11gDataLoadPlan Image 3 resized 600

  • Click RamidiVeeraReddy 2013 06 21 GeneratingOBIA11gDataLoadPlan Image 4 resized 600
  • In the Navigation Panel (on left), click on “Manage Implementation Projects” under “Implementations.”

RamidiVeeraReddy 2013 06 21 GeneratingOBIA11gDataLoadPlan Image 5 resized 600 

  • Create RamidiVeeraReddy 2013 06 21 GeneratingOBIA11gDataLoadPlan Image 6 resized 600 New Implementation Project for Student Information Analytics.

RamidiVeeraReddy 2013 06 21 GeneratingOBIA11gDataLoadPlan Image 7 resized 600

  • Click “Next.”

RamidiVeeraReddy 2013 06 21 GeneratingOBIA11gDataLoadPlan Image 8 resized 600

  • Expand all Oracle Student Information Analytics and Include all the Offerings to Implement and click on “Save and Open Project.”
  • Then click on “Done.”
  • Go back to the BIACM Page and on the Navigation Panel (on left), click on Manage Data Load Parameters” under Data Load Parameters Administration.”

RamidiVeeraReddy 2013 06 21 GeneratingOBIA11gDataLoadPlan Image 9 resized 600

  • Search for the INITIAL EXTRACT DATE.

RamidiVeeraReddy 2013 06 21 GeneratingOBIA11gDataLoadPlan Image 10 resized 600

  • Click on the corresponding “Global Parameter Value” and change it to 1/1/2000.

RamidiVeeraReddy 2013 06 21 GeneratingOBIA11gDataLoadPlan Image 11 resized 600 

  • Change the date and click on “Save and Close.”
  • Go back to the BI Apps Configuration Manager URL and use the BI Apps Administration Credentials to login, making sure that the managed servers (odi_server1 and bi_server1) are up and running.
  • In the Navigation Panel (on left), Select “Manage Load Plans” under “Load Plans Administrator.”

RamidiVeeraReddy 2013 06 21 GeneratingOBIA11gDataLoadPlan Image 12 resized 600 

  • In the Load Plans toolbar, click the “Add” RamidiVeeraReddy 2013 06 21 GeneratingOBIA11gDataLoadPlan Image 13 resized 600  icon. Enter “Name” and “Description.”

RamidiVeeraReddy 2013 06 21 GeneratingOBIA11gDataLoadPlan Image 14 resized 600

  • Click “Next,” to select the “Fact Groups.”

RamidiVeeraReddy 2013 06 21 GeneratingOBIA11gDataLoadPlan Image 15 resized 600

  • Click the “Save” button and select “Save and Generate Load Plan.”

RamidiVeeraReddy 2013 06 21 GeneratingOBIA11gDataLoadPlan Image 16 resized 600 

  • See the status of your Load Plan.

RamidiVeeraReddy 2013 06 21 GeneratingOBIA11gDataLoadPlan Image 17 resized 600

 

  • Once Load Plan is generated, we need to execute it.

RamidiVeeraReddy 2013 06 21 GeneratingOBIA11gDataLoadPlan Image 18 resized 600

RamidiVeeraReddy 2013 06 21 GeneratingOBIA11gDataLoadPlan Image 19 resized 600 

  • See in the Status that it is “Running.”

RamidiVeeraReddy 2013 06 21 GeneratingOBIA11gDataLoadPlan Image 20 resized 600

Congraulations! Data Load Execution is initiated!

 


Veera Reddy Ramidi

Veera Reddy Ramidi is a Senior Business Intelligence Consultant at KPI Partners and works with the expert team within the KPI Partners Offshore Technology Center. His areas of professional focus include OBIEE, Oracle Business Intelligence Applications, Informatica, and DAC.  He has received praise for his functional knowledge in healthcare industries. Check out Veera’s blog at KPIPartners.com.

原创文章,作者:ItWorker,如若转载,请注明出处:https://blog.ytso.com/271357.html

(0)
上一篇 2022年7月3日
下一篇 2022年7月3日

相关推荐

发表回复

登录后才能评论