Step by Step guide for OVR installation

Following component is needed to Install One View Report [OVR]

1. Create Oracle Database
2. Install Repository Creation using [RCU]
3. Install Oracle Business Intelligence
4. Upload boilerplates
5. Configure One View Reports in Enterprise One

1. Create Oracle Database

Oracle database installation is standard process. Hence screenshot is not attached here. We have installed it on OVR Server ‘ovrsvr’ as OVR installation needs database with AL32UTF8 and JD Edwards database non-AL32UTF8. We have not ignored this error as this may create some issues in future.

Install Repository Creation using [RCU]

1. Download the RCU from oracle (link: http://www.oracle.com/technetwork/middleware/downloads/fmw-11-download-092893.html )
2. 
3. You must unzip the file and put it in a easy to access folder. We can consider this folder as an Oracle Home (rcu Home).  In our case we have installed it in D:\\Software\RCU\rcuHome
4. Run the rcu.bat  (Repository Creation Utility) in D:\\Software\RCU\rcuHome\bin

Create OBIEE schemas with RCU : start RCU

The following screen will appear:

Create OBIEE schemas with RCU : Create repository . Choose "Create and load component schemas into a database." and press "Next".

The following screen will appear:

Create OBIEE schemas with RCU : Select Components

Click on "Next". The following screen will appear

Create OBIEE schemas with RCU : Map tablespaces

Choose the tablespace names for the DEV_MDS and DEV_BIPLATFORM schemas.  If you want you can modify some tablespace propreties.  Click on "Next". The following screen will appear:

Create OBIEE schemas with RCU : Create

When the schemas/ tablespaces are created the following screen will appear:

Create OBIEE schemas with RCU : Completion Summary  Click on "Close" and all the stuff is done. Now you are ready to install the OBIEE Server.

Oracle BI Installation [11.1.1.7.0]

Download following part number from e-delivery, extract these zip files and copy to BIP Server [tne9xovr]

Extract directory name

/u01/install/bishiphome/disk1

Bi System User Name :weblogic Password : xyz111

BIPLATFORM Schema Username : DEV_PLATFORM

BIPLATFORM Schema Password: xyz111

MDS Schema Username : DEV_MDS

MDS Schema Password: xyz111

Password : xyz111

Click on Finish.

Upload boilerplates

1. Login to XML sever using http://ovrsvr:7001/xmlpserver/login.jsp
2. Username : weblogic
3. Password: xyz111
4. Click on catalog
5. Click on component
6. Click on Edit
7. Click on Add a New Layout
8. Click on Upload
9. Provide a name for the template, select "BI Publisher Template" as the type, and select "English" for locale
10. Select Upload to save the template Repeat these steps to add the remaining EnterpriseOne template files

Giving the BIAuthor Role Access to the Boilerplates

After the Boilerplates are uploaded, you need to make sure that all users with the BIAuthor role have access to the boilerplates. To give the BIAuthor role access to the boilerplates:

1. Log into BI Publisher with administrator privileges and navigate to the Catalog.
2. In the Shared Folders directory, open the Components folder.
3. Select the Permissions link in the bottom left corner under Components
4. Select the "+" symbol (Create) and then the Search button.
5. Add the BIAuthor role and click OK.
6. Check all the checkboxes for the BIAuthor role and click OK.

2.4 Configuring BI Publisher Users

When configuring BI Publisher users, you need to create a BI Publisher user for each JD Edwards EnterpriseOne user that designs or authors One View Reports. You may set up one proxy user in BI Publisher for all of the JD Edwards EnterpriseOne users who will only be running reports and not authoring them. This will minimize the amount of setup required. However, if you prefer to track each user individually for auditing purposes, you can create a one-to-one relationship by setting up a BI Publisher user for each JD Edwards EnterpriseOne user.

To configure a BI Publisher user:

1. Log into the WebLogic Server Administration Console.

1. Navigate to "Security Realms" and then "myrealm."

1. Select the "Users and Groups" tab and then click "New."

1. Create a new BIP account by providing a name, description, and password, and click OK.
2. In order to add the newly created user to the BI Author group:
1. Find and select your newly created user.
2. Navigate to the "Groups" tab.
3. Select the BIAuthor group and move it under Chosen.
4. Click Save.

Note:

All BI Publisher users must belong to the BIAuthor group.

Password: xyz111

1. Click Save.
2. Verify that you can log on to the Oracle BI Publisher server using your new user information.

Configure One View Reports in Enterprise One

a. Update SoftCoding Template using E1 – P953000

Verifying the One View Reporting BI Publisher Soft Coding using P953000

Create environment specific soft coding records using E1 – P954000

1. Authorize One View Report Feature to user/role – P958974

After completion of above task  sign out from E1 & re-login.

Importing One View Reports - P982402

Click on Add

Click on Load Import File -> choose file 910allreports.zip [downloaded from edelivery]

Click on save

JDE will start importing OVR which is provided by Oracle