Select Page

Art of BI: Turn your OBIEE Sample App VM into a Development Environment

Sherry Milad | | June 30, 2016

OBIEE Development

How do you turn your OBIEE Sample App VM into a Development Environment?

During client engagements you are sometimes faced with Clients having an In-house development team, who also have access to the Test environment you are developing your deliverables and solution for. In this situation, and also as best practice, you should always have your own development environment where you can test your implementation and Proof of Concepts on before the client development team has access to it.

Our development team has initially installed the Sample App v511 for OBIEE 12C on their windows machines in order to implement all Proof of Concepts, including OBIEE 12C new features, to fulfill our client requirements.

After the VM is setup one of the first things to do is to create a shared folder between your local machine and VM.

Steps to create a Shared Folder:

  1. From the main menu bar select Devices > Shared Folders > Shared Folder Settings
  2. In the SampleApp511p – Settings dialog box, Click the folder with a green plus on the right to add a new shared folder
  3. Enter the folder Path on your local machine and the folder name
  4. Check the boxes Auto-mount and Make Permanent as shown below

DEVENV1

Auto-mount is checked to ensure the folder is mounted immediately onto the VM, and Make Permanent ensures that the folder is constantly mounted even after reboot.

  1. Verify that you can access the folder from your VM by navigating to the following path: Places > Computer > Filesystem > Media 

DEVENV2

 

Steps to setup ODBC connections:

  1. On your VM, log into Enterprise manager to Identify the port used by the application [Note: Make sure the BI Database and BI Services have been started]
  2. Note the port used by AdminServer and bi_server1

DEVENV3

  1. Navigate to biinstance and select the Availability tab
  2. Expand the BI Servers process and note the port number for obis1

DEVENV4

  1. Now navigate to Machine > Settings > Network
  2. Click on the Port Forwarding button
  3. Click the Add new Port Forwarding Rule for 7792
  4. Click the Add new Port Forwarding Rule for 7001
  5. Click the Add new Port Forwarding Rule for 7780 and enter the Guest IP 10.0.2.15 OR no IP address at so that it is empty/blank

DEVENV_PORTS

Note: You can bring out the value for Guest IP using the command /sbin/ifconfig in the VM terminal from the inet address.

DEVENV6

  1. Click OK twice to exit the Port forwarding and Machine settings
  2. Now on your local machine, open up the ODBC Data Source Administrator
  3. Go to the System DSN tab and click Add to add a new data source connection
  4. Select the OBIEE 12C driver and click Finish
  5. Enter the name for the ODBC connection and set Server to local and click next
  6. Enter the login ID and Password and the Port number 7792 [obis1 port], and check the Save login ID and Connect checkboxes, and click Next

DEVENV7

  1. If the next page is returned with no errors and you can see the databases, that means you are now connected successfully.
  2. Click Finish and OK to close the data source administrator

Steps to upload the development RPD:

  1. Place the saved RPD onto the VMShare shared folder on your local C drive
  2. In your VM Open up a terminal and navigate to the following path:

cd app/oracle/biee/user_projects/domains/bi/bitools/bin

  1. Then enter the following command to upload the RPD you placed in the shared folder

./data-model-cmd.sh uploadrpd -I /media/sf_VMShare/OBIEE_12c_tst_20160614.rpd -SI ssi -U weblogic -P Admin123

DEVENV8

  1. In the same folder path, stop the OBI services using the command: ./stop.sh
  2. Start OBI Services using the command: ./start.sh
  3. From your local machine log into BI Administration tool online, selecting the VM ODBC connection we created earlier, and enter the Username and Password.
  4. Verify that the RPD shown is your development RPD and not the Original SampleApp RPD.

Steps to loading the development Web Catalog:

  1. Place the saved (archived) Catalog onto the VMShare shared folder on your local C drive
  2. Log into the Analytics portal
  3. Click on Catalog in the global header
  4. Select the Shared Folders under Folders
  5. Click the Unarchive link under Tasks
  6. Browse and select the catalog you wish to unarchive from the VMShare folder
  7. Click OK

Steps to log into Catalog Manager:

  1. From your local machine select the Catalog Manager application
  2. Select File > Open Catalog
  3. Enter the URL as: http://localhost:7780/analytics/saw.dll
  4. And fill in the user name and password and click OK
  5. You should be able to log in successfully and view the Catalog objects you just unarchived.

 

And Finally, you are ready!

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

Hyperion Myth #9: SOX Audit Requests Are Time-consuming

With serious financial penalties, SOX audits can be intimidating — but they don’t have to be. Find out how you can use Datavail’s software to automatically prove SOX compliance.

Jonathan Berry | March 13, 2018

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS