Following component is needed to Install One View Report [OVR]
Create Oracle Database
Install Repository Creation using [RCU]
Install Oracle Business Intelligence
Upload boilerplates
Configure One View Reports in Enterprise One
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]
-
-
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
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
-
Username : weblogic
Password: xyz111
Click on catalog
Click on component
Click on Edit
Click on Add a New Layout
Click on Upload
Provide a name for the template, select "BI Publisher Template" as the type, and select "English" for locale
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:
Log into BI Publisher with administrator privileges and navigate to the Catalog.
In the Shared Folders directory, open the Components folder.
Select the Permissions link in the bottom left corner under Components
Select the "+" symbol (Create) and then the Search button.
Add the BIAuthor role and click OK.
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:
Log into the WebLogic Server Administration Console.
Navigate to "Security Realms" and then "myrealm."
Select the "Users and Groups" tab and then click "New."
Create a new BIP account by providing a name, description, and password, and click OK.
In order to add the newly created user to the BI Author group:
Find and select your newly created user.
Navigate to the "Groups" tab.
Select the BIAuthor group and move it under Chosen.
Click Save.
Note:
All BI Publisher users must belong to the BIAuthor group.
Password: xyz111
Click Save.
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
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
