Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Doubts regarding the OBIEE repository (RPD)

Received Response
22
Views
5
Comments
Fabricio_Jorge
Fabricio_Jorge Rank 3 - Community Apprentice
edited Aug 13, 2024 7:02PM in Oracle Analytics Cloud and Server

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.

Answers

  • krikumar-Oracle
    krikumar-Oracle Rank 1 - Community Starter

    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
    Gianni Ceresa Mod

    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
    Fabricio_Jorge Rank 3 - Community Apprentice

    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
    Thomas Dodds Rank 8 - Analytics Strategist

    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
    Gianni Ceresa Mod

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