Oracle Analytics Cloud and Server

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

Categories

Documenting all Rpd logical and Physical Joins to csv file

Received Response
250
Views
9
Comments
User_SNGC2
User_SNGC2 ✭✭
edited August 13 in Oracle Analytics Cloud and Server

Hi Experts,

I have a requirement to list all the obiee rpd joins into csv or excel file.can anyone of you help me to gather all the information in the efficient way to csv file as it takes lot of time to do manually and in thr utilities-> repository documentation is not giving this kind of information.

Thanks & Regards,

Sandeep

Answers

  • Joel
    Joel ✭✭✭✭✭

    There is a utility that does just that:

    pastedImage_0.png

    pastedImage_1.png

    Select Repository Documentation and click on execute then select a location to save the CSV file.

  • Gianni Ceresa
    Gianni Ceresa mod 
    3934657 wrote:a requirement to list all the obiee rpd joins

    Hi,

    Do you mind be a bit more explicit in what you are after? Maybe with a little example?

    The concept of "join" can have various meanings, so better to be explicit.

    And please also specify the exact version of the tool you are using.

  • Christian Berg-0racle
    Christian Berg-0racle ✭✭✭✭✭

    Looking at this:

    OP probably hasn't tried MDS XML because it's not the format he wants even though it contains precisely what he wants....

  • User_SNGC2
    User_SNGC2 ✭✭

    I have already mentioned you that this is not giving the joins information

  • User_SNGC2
    User_SNGC2 ✭✭

    I have tried MDS XML  but the original requirement is to get the logical join information and if possible physical join information also in to the csv format to all the subject areas and business models in the rpd.

    our business analysts doesn't like the xml format.

    @Gianni Ceresa @christian berg

  • Christian Berg-0racle
    Christian Berg-0racle ✭✭✭✭✭

    You have the information. Just transform it.

  • Gianni Ceresa
    Gianni Ceresa mod

    You have the source, you know what is your target format : not many other ways thank transforming it yourself.

    That's the best you can get ....

    I still have no idea of what the result you hope to find looks like...

    Did you try "Tools" > "Query Repository" ?

    You can export the result of queries in CSV ...

    Just don't expect something giving you exactly what you are after: you have "Repository Documentation" and "Query Repository".

    Other than that you have to get the info yourself and transform (by finding it inside the XML files).

  • User_SNGC2
    User_SNGC2 ✭✭

    I got bunch of mdl folders that contains mdl files and when I try to query rpd  subject area using the option you mentioned it didn't give all the objects that tied to subject area.

  • Christian Berg-0racle
    Christian Berg-0racle ✭✭✭✭✭

    For the Nth time in this thread and the other thread: Pure. XML. Output.

    ONE file. Not multiple: biserverxmlgen

    https://docs.oracle.com/cd/E17904_01/bi.1111/e16364/xml_about.htm#BIEIT1342

    And then you can load it into a table and query it or do whatever you want. You also need to actually do things. We won't write code for you.