How are OBIEE Metadata files stored ?

The metadata for an OBIEE Instance is stored both as Database tables and as Physical files.

Metadata in Database tables are stored in the Metadata Schema's

MDS (Metadata Services Schema)

BIPLATFORM 

The Physical metadata files for OBIEE are the

• Repository (RPD)
• Catalog Files

The repository file can be found at the following location and will have the extension .rpd. 

MW_HOME/instance/instance1/config/OracleBIServerComponent/coreapplication_obips

The currently active RPD name can be checked from EM or from the instanceconfig.xml file. The repository file contains the details of Physical Tables, Physical and logical mappings, Presentation tables etc. 

The catalog files are located the physical directory below,

MW_HOME/instance/instance1/config/OracleBIPresentationServiceComponent/coreapplication_obips1

The catalog contains Metadata for reports,prompts, dashboards etc and their permissions. The physical directory for the latest catalog displayed can be found from the EM.