KPI Partners Blog

OBIA 11g Domain Load to Business Analytics Warehouse

Posted by KPI Partners News Team on Thu, Jul 11, 2013 @ 02:05 PM

by Veera Reddy Ramidi

This blog introduces and explains the detailed step by step process for executing the Domain 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.

 

Examining Oracle BI Apps 11g: The Series

 

To start, go to the BI Apps Configuration Manager URL and use the BI Application Administration Credentials to login, making sure that the managed servers (odi_server1 & bi_server1) are up and running.

Registering Source Systems and Propagating Connection Details to ODI

  • Select "Define Business Intelligence Applications Instance" under "System Setups," in the Navigation Panel (left side) of the web page.

RamidiVeeraReddy 2013 06 21 OBIA11gDomainLoadtoBusinessAnalyticsWarehouse Image 1 resized 600 

  • In the right side panel under the "Source Systems" Tab, click on the Add RamidiVeeraReddy 2013 06 21 OBIA11gDomainLoadtoBusinessAnalyticsWarehouse Image 2 resized 600  Icon to get the "Register Source Dialogue" window. Then select the "Product Line" and "Data Server" details as below:

RamidiVeeraReddy 2013 06 21 OBIA11gDomainLoadtoBusinessAnalyticsWarehouse Image 3 resized 600

  • Click "Next" to get the "Register Source" in Oracle Data Integrator Topology.

In this Register Source Topology do the following:

  • Select "Global" from the "Context" drop-down list.

RamidiVeeraReddy 2013 06 21 OBIA11gDomainLoadtoBusinessAnalyticsWarehouse Image 4 resized 600

  • Edit the Connection details in the "Technology: Oracle" Tab as below:

RamidiVeeraReddy 2013 06 21 OBIA11gDomainLoadtoBusinessAnalyticsWarehouse Image 5 resized 600

  • Click on the "Test" button to verify if the connection works.

RamidiVeeraReddy 2013 06 21 OBIA11gDomainLoadtoBusinessAnalyticsWarehouse Image 6 resized 600

  • Edit the Connection details in the in the "Technology: File System" Tab as below:

The path to the file is <MW_Home>\< ODI1orBI1_ Home>\etl\data_files\src_files\PSFT_9_0

RamidiVeeraReddy 2013 06 21 OBIA11gDomainLoadtoBusinessAnalyticsWarehouse Image 25 resized 600

  • Click RamidiVeeraReddy 2013 06 21 OBIA11gDomainLoadtoBusinessAnalyticsWarehouse Image 7 resized 600

 

NOTE: The connection details are not propagated to the ODI Repository until you have entered and saved the information on both the "Register Source in Configuration Manager" page and the "Register Source in Oracle Data Integrator Topology" page.

  • On the "Overview" page you can see "Oracle Student Information Analytics."

RamidiVeeraReddy 2013 06 21 OBIA11gDomainLoadtoBusinessAnalyticsWarehouse Image 8 resized 600
 

Enabling Offerings for Deployment

  • Select "Manage Business Intelligence Applications" under "System Setups" in the Navigation Panel on the left side of the web page.

RamidiVeeraReddy 2013 06 21 OBIA11gDomainLoadtoBusinessAnalyticsWarehouse Image 9 resized 600

  • Select "BI Application Offerings Tab," then select the "Enable the Checkbox" next to each offering you want to deploy. Click on "Save" to save your changes.

RamidiVeeraReddy 2013 06 21 OBIA11gDomainLoadtoBusinessAnalyticsWarehouse Image 11 resized 600

  • To exit this dialogue, click "Done."

Editing Preferred Currency Display Names and Enabling Document Currency (Optional Step)

This is an optional step where you can "Manage Preferred Currencies," if required.

  • Select "Manage Preferred Currencies" under "System Setups" in the Navigation Panel on the left side of the web page.

RamidiVeeraReddy 2013 06 21 OBIA11gDomainLoadtoBusinessAnalyticsWarehouse Image 12 resized 600 

  • To edit the "Currency Code," if needed, click on the required "Preferred Currency Name" in the Managed Preferred Currencies page and then change the currency as below.

RamidiVeeraReddy 2013 06 21 OBIA11gDomainLoadtoBusinessAnalyticsWarehouse Image 13 resized 600

  • Click on "Save and Close."

Setting Languages for Data Load into the Business Analytics Warehouse (Optional Step)

  • Select "Manage Warehouse Languages" under "System Setups" in the Navigation Panel on the left side of the web page.

RamidiVeeraReddy 2013 06 21 OBIA11gDomainLoadtoBusinessAnalyticsWarehouse Image 14 resized 600 

NOTE: When you mark a language as Installed, the Data Load Parameter LANGUAGE_LIST is populated internally with the list of selected languages. This parameter list is used during data extraction to extract data in the selected languages. American English is the default installed language. All other languages are disabled.

If you prefer to install additional languages, change the status of the required Language from ‘Disabled’ to ‘Installed’. Set the Base Language by selecting the Language record and clicking the Set Base Language icon in the table toolbar. By default, American English is the Base Language.

The base language is used to generate pseudo-translation records in Oracle Business Analytics Warehouse for any languages missing in the Source system.

RamidiVeeraReddy 2013 06 21 OBIA11gDomainLoadtoBusinessAnalyticsWarehouse Image 15 resized 600

  • Click "Save" to save your changes.

Running the Domains Load Plan

  • Select "Manage Load Plans" under "Load Plans Administrator" in the Navigation Panel on the left side of the web page.
  • In the Load Plans toolbar, click the Add RamidiVeeraReddy 2013 06 21 OBIA11gDomainLoadtoBusinessAnalyticsWarehouse Image 16 resized 600 icon. Enter Name and Description. Load Plan Type should be Domain-only Extract and Load (SDE and SIL)

RamidiVeeraReddy 2013 06 21 OBIA11gDomainLoadtoBusinessAnalyticsWarehouse Image 17 resized 600

  • Click "Next."
  • Select the "Fact Groups," which need to be included in Load Plan

RamidiVeeraReddy 2013 06 21 OBIA11gDomainLoadtoBusinessAnalyticsWarehouse Image 18 resized 600 

  • Click the "Save" button and select "Save and Generate Load Plan."

RamidiVeeraReddy 2013 06 21 OBIA11gDomainLoadtoBusinessAnalyticsWarehouse Image 19 resized 600 

See the status of your Load Plan.

RamidiVeeraReddy_2013_06_21_OBIA11gDomainLoadtoBusinessAnalyticsWarehouse_Image_23

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

RamidiVeeraReddy 2013 06 21 OBIA11gDomainLoadtoBusinessAnalyticsWarehouse Image 20 resized 600

RamidiVeeraReddy 2013 06 21 OBIA11gDomainLoadtoBusinessAnalyticsWarehouse Image 24 resized 600

See that the Status it is running.

RamidiVeeraReddy 2013 06 21 OBIA11gDomainLoadtoBusinessAnalyticsWarehouse Image 21 resized 600

Congratulations, you are done with domain load!

RamidiVeeraReddy 2013 06 21 OBIA11gDomainLoadtoBusinessAnalyticsWarehouse Image 22 resized 600

 


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.

Tags: Student Information Analytics, Data Warehousing, OBIEE, Veera Reddy Ramidi, Oracle, Business Intelligence, Tutorial, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Blog



Subscribe to the KPI Blog