Oracle

Installing OBIEE Suite

• Install Microsoft Loopback Adapter, go to its IPv4 setting, and give a static IP 192.168.1.41 and subnet mask 255.255.255.0. Leave other fields blank.

• Add the following lines to C:\Windows\System32\drivers\etc\hosts: ("orcl" will be the name of the database service)

127.0.0.1 localhost
192.168.1.41 orcl orcl.oradev.oraclecorp.com

• Go to Oracle Technology Network (otn.oracle.com) and install Oracle Database 12c ("winx64_12c_database_1of2.zip") using the same name "orcl"

• Install RCU ("ofm_rcu_win_11.1.1.7.0_64_disk1_1of1.zip") to create schema

• Install Oracle WebLogic Server 11gR1 (10.3.6) + Coherence - Package Installer Generic 64-bit ("wls1036_generic.jar") to a new folder (e.g. C:\app\BI)

• Install OBIEE 11.1.1.7.0 to the same folder with the "software only install" option

• Run Oracle_BI1/bin/config.bat to start configuration

Setting Up Hosted Windows Dev Environment

Use "Microsoft Windows 2008 Enterprise R2 (Intel x64, Developer)" image for your hosted machine. (Need MSDN license.)

Make sure you have ORADEV account. If you do not have ORADEV account password,

• sign in to Oracle Identity Manager
• My Access - Accounts - Windows Unified Domain - Reset Password. (or create account - Windows Unified Domain)

Log-on using remote desktop (run "mstsc").

username: ORADEV\YOURGLOBALID

Run Visual Studio 2010 X64 Command Prompt (Administrator).

get Kerberos ticket

ade okinit

create ADE view

ade createview YOURVIEWNAME -series BIFNDN_MAIN_WINDOWS.X64 -populated

use ADE view

ade useview YOURVIEWNAME

Start IDE - inside your view

cd C:\ADE\YOURVIEWNAME\bifndn\analytics_web\main
startide.bat

Using Command Line (sawbuild.bat) to build - inside your view

cd C:\ADE\YOURVIEWNAME\bifndn\analytics_web\main
sawbuild bipsmatsbuildlite (for debug version, "sawbuild r bipsmatsbuildlite" for release version)

Then run.

sawbuild preparemats
setenv
sawserverD -updateGuidAndStart 

Running BI in your browser

Install tomcat 7.0 (everything default, username/pass: admin/admin)

Go to tomcat directory C:\Program Files\Apache Software Foundation\Tomcat 7.0\conf\Catalina\localhost\ and create a file tyun.xml.

// tyun.xml
<Context docBase="C:/ADE/tyun_view/bifndn/analytics_web/main/app-link" />

Open browser and go to http://localhost:8080/tyun

log in Administrator / Admin123

Visual Studio Set-ups and Tips

Setting up and Using Visual Studio (8/13/2013)

• Indentation

Tool - Options - All Languages - Tab
Tab size: 3
Indent size: 3
and check "Insert spaces".

• Overwriting autoexp.dat file

Copy C:\ADE\tyun_view\bifndn\analytics_web\main\support\visualstudio\AUTOEXP.DAT
and paste to the
C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\Packages\Debugger\autoexp.dat
(make a backup before you overwrite the file)

• Shortcuts

Ctrl + F7: compile only this file

• Adding breakpoints

right click on the desired position - breakpoint - Insert breakpoint

• Adding a subSystem (called hello)

Inside C:\ADE\tyun_view\bifndn\analytics_web\main\project\websubsystems\sssearch.cpp,

define function:

// hello world
void SearchSubsystem::hello(NQHttpStream & httpStream,
                                 const saw::Handle<ClientSession>& hClientSession, const HttpArgs & rArgs)
{
   NQWString hello = L"hello world";
   httpStream << hello;
}

and add the following in an appropriate location

// hello world
   SAW_ADD_HTTPCOMMAND(rRegistrar,hello,                 SearchSubsystem, kNormalCall);

Now define the function inside a header file sssearch.h in the same directory:

//hello world
   void hello(NQHttpStream & rStream, const saw::Handle<ClientSession>& hClientSession, const saw::HttpArgs & rArgs);