Datawarehouse Architect

The process of refreshing GUID came into place when we migrate the solution to production or else done some changes in server level but you could not find impact of the changes to you done. This is were refreshing GUID in OBIEE 11g and OBIEE 12c taken place. There are 2 files which you need to change for doing GUID refresh in OBIEE 11g and OBIEE 12c (NQSConfig.INI and instanceconfig.xml)     Note 1: Please take one backup before you doing anything with this files so that if something goes wrong you can replace with it. Note 2: Stop the weblogic server from EM GUID Refresh in OBIEE 11g & OBIEE 12C ==================== instanceconfig.xml ================================= 1. Open the instanceconfig.xml file for editing. This file is located at,  <ORACLE_INSTANCE>/config/OracleBIPresentationServicesComponent/coreapplication_obips1/.  2. Locate the Catalog XML element which should contain only the UpgradeAndExit subelement.  ...

Below are the steps for Installing ODI (Oracle Data Integrator) Pre_ Request: Installed Oracle Data Base 11g Installed JDK 1.7 Install ODI: Download ODI11.1.1.9 from the Below link http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index-100710.html     Download RCU From the same Link For 11.1.1.9 ExtractThe ZIP files For ODI Then Start Installing the RCU For the ODI Navigate C:\ODI_11.1.1.9.0\rcuHome\BIN Insert the database connection Then insert password for the schema Then next Then next Here it’s going to Create The Temp Tables for The Work And Master Repo Start installing ODI Navigate to C:\ODI_11.1.1.9.0\ODI11.1.1.9\Disk Run The EXE with jreLoc NO

Creating new Report in BI Publisher Create a new report ‘Department_Details’ inside the created folder ‘BI_Publisher_LabGuide’ Click on Edit link mentioned below to create the report Creating new Data Model Select Data model à New Enter the data model name àselect the type as SQL Query Choose the data source Write the SQL Query SQL query can also be generated using SQL Builder which is discussed in the next example. Save the report View the report The output could be viewed only in the data format, as we have not created any template for the report. Click the view button to view the output. The output generated will be in the form of XML. You can also edit the report by clicking the Edit link. After editing, Save the report and view it as we have discussed already. Viewing the Report in Different formats Here we can view the above created report in various formats using Template. Creating Default Template Select the Layouts, and click the Generate button to create a new RTF templ...