Generate and Deploy metadata dictionary in OBIEE 11g

Generating Repository Documentation:


1.  Open RPD in offline mode.
2. Go to Tools->Utilities.
3. Select "Generate Metadata Dictionary" and click Execute.

4. Browse to the desired location where you want generate the metadata dictionary and Click Ok.

5. Metadata dictionary folder will have the same name as RPD.

Deploying Metadata Dictionary:

1. Create a folder named “metadatadict” under the following path.

<OBIEE_HOME>\OBIEE11G\instances\instance1 

2. Copy WEB_INF folder from below path to metadatadict folder created above.

D:\OBI\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\analyticsRes

3. Copy the generated metadata dictionary in the following location. D:\OBIEE11G\instances\instance1\metadatadict

IMPORTANT Note :

The generated metadata dictionary folder name “Order_Entry” in the path \installhome\instances\instance1\metadatadict should be the same as the rpd name that is online currently. If your rpd name has changed to say Order_Entry_BI00002 or Order_Entry_BI00003, then change the directory name of the Order_Entry under metadatadict to the same name as the rpd.

4. Go to console using the following link.

http://your11gserver:6001/console

5. Click "Lock & Edit". Navigate to Deployments and select Install button

6. Specify  the path of metadata dictionary and select as shown. Click Next.

7. Choose Install this deployment as an application and click Next.

8. Choose I will make the deployment accessible from the following location and click Next.

9. Navigate to Deployments. Go to metadatadict in deployments table.

10. Click on Start-> Servicing all requests.

11. Now the metadatadict changed to Active state

12. Update the instanceconfig.xml file.

Open the file instanceconfig.xml and add following entries between tags <ServerInstance> and Restart BI Presentation Services.

<SubjectAreaMetadata>

<DictionaryURLPrefix>http://your11gserver:7001/metadatadict/</DictionaryURLPrefix>

</SubjectAreaMetadata>

13. Login to answers and go to order entry subject area.

14. Select the subject area or table and Click on the icon for Metadata Dictionary circled in red as shown below.

You can see the metadata dictionary for the selected item as shown above.

OBIEE 11.1.1.5 Installation (Enterprise Install)

Here is the detailed and step by step process for OBIEE 11g Installation..


Create a separate Database Schema before installing 11g.

Unzip rcuhome folder and run rcu.bat file

Specify all database details and give the user name and pwd of the Database Schema we created earlier.

Goto OBIEE setup folder and run the setup file.

Specify a location for installation (D:\OBIEE11G in my case)

Choose Auto Port Configuration if you want the default port numbers (prefer this if you don't have obiee 10g installed in your system)

If you have 10g installed in your machine and need to specify different ports, choose: "Specify Ports using Configuration File"

Locate the "staticports" text file which contains the below script or you can directly copy the script using view/edit file option.

==================================================

[WEBLOGIC]

#The Domain port no. This is the listen port of WeblogicAdminserver for the domain.

Domain Port No = 6001

#The "content" port for the BIEE apps. This is the Weblogic Managed Server port on which BIEE applications are deployed.

Oracle WLS BIEE Managed Server Port No = 8704

#The SSL port for the Weblogic Managed Server

Oracle WLS BIEE Managed Server SSL Port No = 8804

[OPMN]

#Process Manager Local port no

Oracle Process Manager Local Port No = 6700

#Process Manager Remote port no

Oracle Process Manager Remote Port No = 6701

#Process Manager Request port no

Oracle Process Manager Request Port No = 6702

[BIFOUNDATION]

#The listen port for OracleBIServer component 

Oracle BI Server Port No = 8703

#The monitor port for OracleBIServer component 

Oracle BI Server Monitor Port No = 8701

#The listen port for OracleBIPresentationServices component 

Oracle BI Presentation Services Port No = 8710

#The listen port for OracleBIScheduler component 

Oracle BI Scheduler Port No = 8705

#The monitor port for OracleBIScheduler component 

Oracle BI Scheduler Monitor Port No = 8708

#The script RPC port for OracleBIScheduler component 

Oracle BI Scheduler Script RPC Port No = 8707

#The listen port for OracleBIClusterController component 

Oracle BI ClusterController Port No = 8706

#The monitor port for OracleBIClusterController component 

Oracle BI ClusterController Monitor Port No = 8700

#The listen port for OracleBIJavaHost component

Oracle BI JavaHost Port No = 8810

=================================================