Doubts regarding the OBIEE repository (RPD)

Question

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 SourceAnalyticsWeb

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.

Gianni Ceresa · Answer

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).

Thomas Dodds · Answer

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.

Fabricio_Jorge · Answer

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.