Doubts regarding the OBIEE repository (RPD)

Fabricio_Jorge

Hi all,

   OBIEE...: 12.2.1.0.0

   OS........: OEL 7.1

   I have a doubt regarding the OBIEE Repository (or repositories???) and i hope some of the most experienced fellows can help me:

      1) How many repositories exists in OBIEE? Doing some researches, i found that there is a Repository Metadata (RPD), located in "$DOMAIN_HOME/bidata/service_instances/<SSI>/metadata/datamodel/customizations". Is this the only (and main) repository used by the OBIEE?

      2) Is the Physical Presentation catalog another repository? In Analytics console (Advanced), i saw the following message:

Physical Presentation Catalog Path	/u01/obiee12c/user_projects/domains/bi_dev/bidata/service_instances/ssi/metadata/content/catalog/root
Oracle BI Server Data Source	AnalyticsWeb

         Maintenance Mode is currently off.

      3) The Repository Metadata (RPD) is the only place where i can do the configurations regarding data access, correct? I mean, there is the only place that i can configure the datasources, Subject areas and etc, correct? I know that the Repository Metadata can only be edited using the Administration Tool client.

Thanks for the patience and attention.

krikumar-Oracle

You may want to check OBIEE Metadata Repository Deployment Guide:

https://docs.oracle.com/cd/E57474_01/PDF/Installation/Third%20Party%20Software%20Installation/OBIEE%20Metadata%20Reposit…

Gianni Ceresa

Hi,

In 12c things are changing a bit but right new the answers are still "easy":

1) Only one single repository (multi instance is one of the coming feature of 12c but for now it's still only one). Because of this new multi instance architecture things are a bit different on the disk, but there is still only one RPD in your BI server.

2) No, a RPD contains the 3 layers, it's one single thing and is not divided by layer.

3) Yes, the RPD is the only place where you define physical connection, business models, subject areas.

Fabricio_Jorge

Thank you all for the attention and help.

So, if i want to alter my Metadata Repository, i must copy the .rpd file from my Oracle BI Server to my desktop, open it in OFFLINE mode and update according to my demands, correct? Question: The "liverpd.rpd" is the Metadata Repository file that i must copy/edit, correct?

In 12c, i've read that there is a new procedure to copy, using the "downloadrpd" command. Second question: Is there another way for me to edit the Metadata Repository? I mean, can't i connect The Admin Tool in my desktop directly into the Oracle BI Server?

Thanks again for the help.

Thomas Dodds

You can connect online in 12c... but then it's up to you to make no errors ...you are better off pulling a copy making changes, validating your changes and deploying via the prescribed methods in the docs (yes 12c is different) - better safe than sorry.

Gianni Ceresa

Do what Thomas posted.

Don't do at all a filesystem copy of what you guess is the RPD from the server to your desktop and back.

12c changed many things around how the RPD is managed, so you must get a local copy using the provided tools (command line script to download /upload the RPD).