Where to copy sh.rpd in OBIEE installation folder??

Many OBIEE enthusiasts found this problem.

Where to paste the downloaded SH.zip contents.
If you are following Oracle by Example, then you must download the sh.zip folder and copy the contents in the OBIEE installation folder as told below.

Q: The installing OBIEE tutorial says to copy file sh.rpd from <InstallDrive>\SetupFiles, but there’s no SetupFiles directory?

The instructions here can be a little confusing.  Oracle first states that

  The installation creates a sample repository file (paint.rpd) in <InstallDrive>\OracleBI\server\Repository.

and then it goes on to say

  Copy sh.rpd from \SetupFiles to \OracleBI\server\Repository.

In the prerequisites for the tutorial Oracle states that you must have access to schema SH (which you will have by default in the later database versions).  The small print associated with this section describes how to download file “SH.zip”, and in doing so gives the impression that the download is only required if you don’t have the SH schema installed.  However, “SH.zip” is required irrespective of whether you have access to the SH schema.  You’ll find the file you’re looking for, “sh.prd”, in directory “SH/sh” after you unzip the file. 

Q: I’ve downloaded “SH.zip” to the SetupFiles folder, but I can’t find “sh.rpd” / “SH_PartTwo.rpd”?

A number of the tutorials require, as a prerequisite, that you carry out the following task:

  Create a directory named SetupFiles under <InstallDrive>. Download and extract the SH.zip file from here to this directory named SetupFiles.

Having done the download for one tutorial, then – like any reasonably minded person – when you see the same words in the next tutorial you are apt to assume that you have already completed the task, and conclude that you don’t have to do it again.  Not so!  Different tutorials use different versions of “SH.zip”.  For example, tutorials one and three use the same version, one that contains a repository called “sh.rpd”; tutorial two uses a version that contains a repository called “SH_PartTwo.rpd”; tutorial eight also uses a repository called “sh.rpd”, but it's a different repository from the one used by tutorials one and three:

  Tutorials 1&3:

 http://www.oracle.com/technology/ ...... obe/obe_bi/bi_ee_1013/saw/files/SH.zip 10

  Tutorial 2:

 http://www.oracle.com/technology/ ...... obe/obe_bi/bi_ee_1013/bi_admin/files/SH.zip

  Tutorial 8:

 http://www.oracle.com/technology/ ...... obe/obe_bi/bi_ee_1013/mude/files/SH.zip