When you load an OBIEE 11g resource, Metadata Manager connects to the Presentation Server to extract the metadata for the reports. However, Metadata Manager cannot extract the schema metadata directly from the repository. The OBIEE schema metadata is stored in a RPD file. Because Metadata Manager cannot read RPD files, you must convert the RPD file to an XML file.

Metadata Manager extracts the schema metadata from the XML file, extracts the reports from the Presentation Server, and links the reporting metadata to the presentation model when you load the resource.

You can use the

biserverxmlgen

command line utility to convert a RPD file to an XML file. This utility is part of the OBIEE server installation. Before you run the utility, you must run the run bi-init script to launch the prompt window that is initialized to the Oracle instance. The script file is available in the following location:

ORACLE_INSTANCE/bifoundation/OracleBIApplication/coreapplication/setup

.

Use the following command to convert the repository RPD file to an XML file:

where,

repository_pathname is the name and location of the repository file from which you want to generate XML.

password is the repository password.

output_file_pathname is the name and location of the XML output file you want to generate.

Specify -8 to use UTF-8 encoding in the generated XML file. By default, the generated XML file uses ANSI ISO-8859-1 encoding.