This discussion is archived
6 Replies Latest reply: Feb 5, 2013 1:31 PM by chillychin RSS

Point localhost OBIEE instance to specific RPD

chillychin Newbie
Currently Being Moderated
Im a bit new to OBIEE and am trying to figure out how to get things to work in a multi user development enviorment

I was hoping I would be able to simply download the RPD file that I need to work on to my local host

From there, I can then open it in a web based browser as usual and make all my report changes.

Resave it and re upload/merge this into the main RPD

What I am having problems with is how do I get my downloaded RPD to actually show up in a web based url?

Any help is appreciated

Thanks
  • 1. Re: Point localhost OBIEE instance to specific RPD
    Srini VEERAVALLI Guru
    Currently Being Moderated
    When you check out a new rpd file created in your local folder, if you set that in nqsconfig you might validate using reports, provided connection pool settings and any other..

    Just try it out I never tried the same. let us know how it works
  • 2. Re: Point localhost OBIEE instance to specific RPD
    user2534719 Newbie
    Currently Being Moderated
    I am not sure but you can't work in RPD using web based browser.

    Each user willing to work in RPD will have to have OBIEE client installed on local machine.

    Then the system DSN must be created to connect the database RPD is pointing to as specified in connection pools.

    mark if that helps.
  • 3. Re: Point localhost OBIEE instance to specific RPD
    chillychin Newbie
    Currently Being Moderated
    Right, I have OBIEE installed on my local machine

    I can open the default "Sales" sample reports but I want to point to my own RPD file that I checked out and run it.

    I can run it/open it in Administration and catalog but just cant get it to open in presentation services...

    I tried changing my "default repository" in ODBC to my RPD but it is not letting me connect still showing me the old sales sample...
  • 4. Re: Point localhost OBIEE instance to specific RPD
    chillychin Newbie
    Currently Being Moderated
    Solved this after a lot of googling

    Hope this helps any future readers

    To set up a local instance of your RPD file that you download from another server (there by replacing the default sales RPD) follow these steps

    Download and input rpd file into

    C:\OracleBI\server\Repository

    Configure the nqs file to point to your new RPD file name located in

    C:\OracleBI\server\Config

    Create new blank catalog folder and name it same name as rpd file located here

    C:\OracleBIData\web\catalog

    After all this, you can "copy" and "paste" the catalog from an online catalog manager and paste it into your offline catalog (into the folder that you just created)

    Remember to restart the presentation services in order for the changes to take effect!

    At first permissions will not be set to allow you to view your dashboards

    To set up permissions go to the following URL

    <computername>:9704/analytics/saw.dll?PrivilegeAdmin&_scid=1cJYoJX6psU&Done=Admin

    Keep in mind that whatever username and PW you used to initially download the RPD will follow you through out this process

    Hope this helps anyone else in the future

    Edited by: chillychin on Feb 5, 2013 10:40 AM
  • 5. Re: Point localhost OBIEE instance to specific RPD
    Srini VEERAVALLI Guru
    Currently Being Moderated
    Thats what I've suggested in short!.

    You would have post here instead of lot of googling.

    Thanks for follow-up

    Edited by: Srini VEERAVALLI on Feb 5, 2013 1:15 PM
  • 6. Re: Point localhost OBIEE instance to specific RPD
    chillychin Newbie
    Currently Being Moderated
    Yes Srini you did suggest that in short

    But as I mentioned, I am a bit new to OBIEE and needed a bit more detail then as your suggestion to simply download the RPD file, configure the nqs file and other pool settings

    I dont understand what you mean by I could have posted here instead of a lot of googling?

    If I knew what to post, I wouldnt need to ask in the first place.

    Regardless I would still need to do a bit of googling to figure out the exact file paths, what you meant by the nqs file, the extra step of adding a new catalog folder, pulling down the catalog as well and the URL to find the administration link to set permissions.

    I do appreciate your input, and do have additional questions that hopefully you can provide more detailed input

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points