Oracle Business Intelligence 12c: Generate a metadata dictionary in OBIEE 11g (Manual Method)

Keep in mind, you can generate metadata only in offline mode of a repository. Also note that this is Windows-Only Utility.

Open the repository using the OBIEE Administration tool in offline mode.
Navigate to Tools > Utilities > Generate Metadata Dictionary > Execute

Specify a directory location where you want this metadata should get exported, here I have given C:\OBIEE_Things\Metadata

You should see a below message on a completion of this task.

Now copy WEB-INF folder from $INSTANCE_HOME\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\analyticsRes to C:\OBIEE_Things\Metadata
This would create a directory named as your repository name under the specified location. Here, "ABC".
Rename this directory to the name as it is on the server. This is a mandatory step.

Note that, you can find this name in NQConfig.INI configuration file or else go to EM > Business Intelligence > coreapplication > Deployment > Repository. Here, it is ABC_BI0010

Now login to Console (with admin privillage) to deply this metadata as an application.
Deployments > Lock and Edit > Install.

Specify Path as C:\OBIEE_Things\Metadata and select the radio button for ABC.

Note that, without copying WEB-INF folder to the metadata directory, the ABC directory cannot be deployed as an application in Weblogic, an application in weblogic needs deployment descriptor file (WEB-INF/web.xml)

Click Next > Select Install this deployment as an application (this is selected by default)

Click Next > Select bi_server1 > Click Next.

Select I will make the deployment accessible from the following location > Click Next.

Select Yes, take me to the deployment configuration screen (this is selected by default) and click Finish.

Click Activate Changes.
Once the changes are activated, click on Control tab > Lock and Edit > select ABC > Select start > Servicing all requests. > Click Yes > Click Release Configuration.

Edit instanceconfig.xml and add the following after first ServerInstance tag:
Location of instanceconfig.xml is $INSTANCE_HOME\config\OracleBIPresentationServicesComponent\coreapplication_obips1

<DictionaryURLPrefix>http://obieenow.localdomain:9704/Metadata/</DictionaryURLPrefix>

</SubjectAreaMetadata>

Save the changes.

Go to EM and restart the services.
Log in to analytics as user with BIAdministrator privileges.
Click Administration > Manage Privileges > Access to Metadata Dictionary. Make sure the users have Access to Metadata Dictionary privilege.
Log in as user who has Access to Metadata Dictionary.
Click New > Analysis > Select Subject Area > Click on Metadata Dictionary.