Datawarehouse Architect

Navigate to Programs > Oracle Business Intelligence > Administration. Launch Oracle BI Administration. Open the Oracle BI Repository 'OracleBIAnalyticsApps.rpd 'in offline mode. From the menu, select Manage > Variables In the tree structure in the left pane of the variable manager window, select Repository > Variables > Static In the right pane, double-click on OLAP_DSN to edit this variable. In the Default Initializer field, enter 'ORCL'. Click OK to return to the variable manager window In the right pane, double-click on OLAP_USER to edit this variable. In the Default Initializer field, enter 'BAW'. Click OK to return to the variable manager window In the right pane, double-click on OLAPTBO to edit this variable. In the Default Initializer field, enter 'BAW'. Click OK to return to the variable manager window In the right pane, double-click on OLTP_DSN to edit this variable. In the Default Initializer field, enter 'R12PLY...

Click on Execute. In the Execution Plan tab, select 'Custom_R12_Financials' which is the execution plan that just created for Financials Check the "Full Load Always" and "Drop/Create Indexes" box. Click Save Click the "Run Now" button Click Yes Click OK Click the "Current Run" tab to monitor the process Click Auto Refresh to choose the automatic refresh frequency Navigate to Run History tab, click on the "Run Status" to check the status. It should return with the status 'Completed'

Copy ParameterfileDW.txt and ParameterfileOLTP.txt files from OracleBI DAC Metadata directory to DAC101341 Informatica Parameters directory For example OracleBI DAC Metadata = C:\OracleBI\dwrep\DAC_metadata\DAC_Server DAC101341 Informatica Parameters = D:\oracle\DAC101341\bifoundation\dac\Informatica\parameters\input

Navigate to the Execute page. In the Execution Plans tab, click on the New tab. Enter the name Custom_R12_Financials. Check 'Full Load Always' and 'Drop/Create Indices' box. Uncheck 'Analyze' box. Click Save Click the Subject Areas tab, click Add/Remove icon Click Query Enter a new query for Name = Financials%, click Go Click 'Add All' to select all the subject areas Click OK to return to Choose Subject Areas screen Click OK In the Parameter tab, click 'Generate' Click Yes to proceed Screen shows the progress Click OK to set the new values for Execution plan parameters Use the dropdown box in Value column to set the values for the parameters Execution parameters value SDE_ORAR12_Adaptor : SDE_ORAR12_Adaptor SILOS: SILOS PLP: PLP DBConnection_OLAP: DataWarehouse DBConnection_OLTP: ORA_R12 FlatFileConnection: ORA_R12_flatfile Click Save From Execution Plans, click Build to build to the Execution Plan. Click OK for Selected...

Create a Copy of the Oracle R12 DAC Container for Editing Be sure that the Database, DAC Server, and Informatica Services are running. Start the DAC Client. Select Connection 'dac_repository'. Enter User name and Password 'Administrator/Administrator'. Click Login In the DAC's menu bar, click File > New Source System Container Enter an ID and a name for the container; for example, 'CustomOracleR12' and 'Custom Oracle R12' (The ID and Name fields are alphanumeric. The Name can contain spaces but the ID cannot). Check 'Create as a Copy of Source System Container' button. Select the existing container 'Oracle R12' from the dropdown list, and then click OK Screen shows the progress Once the container creation process is successfully completed, click OK In the Tool bar, Click Assemble to assemble all the subject areas, with dimension and related tables as well When prompted, select 'All records in the list'. Click O...

Navigate to Start > All Programs > DataWarehouse Administration Console Oracle 10g – xxx. Click Start Server Start DAC Client., enter User name and Password 'Administrator/Administrator'. Click Login At first the connection icon is red, then it changes to orange, assuming you have configured correctly. Connect your machine to Oracle network. Test all the connections again. Informatica Integration Service Informatica Repository Service Physical Data Source – DataWarehouse Physical Data Source - ORA_11_5_10 Physical Data Source – ORA_R12