Automating OBIEE Startup and Shutdown Service


As we all know that there are couple of steps that we need to adhere before starup OBIEE services and also same for shutdown . How if it will be automated through two scripts only …i.e one for Startup and other for Shutdown OBIEE service . This utility necessarily free us from juggling around windows services .

Lets find how the tid-bit applicable for IIS Web server first . I have two batch file in desktop that do the stuff for me one is : OBIEE Start-IIS.bat having below script behind it .

===========================
cls
echo “Starting BI ……”
net start IISADMIN
net start W3SVC
net start “Oracle BI Server”
net start “Oracle BI Java Host”
net start “Oracle BI Presentation Server”
start iexplore “http://localhost/analytics/saw.dll?Dashboard&NQUser=Administrator&NQPassword=Administrator
===========================

Another one for stopping BI Services i.e OBIEE Stop-IIS.bat having underline script .

===========================
cls
echo “Stopping BI ……”
net stop “Oracle BI Presentation Server”
net stop “Oracle BI Java Host”
net stop “Oracle BI Server”
net stop IISADMIN /Y
===========================

N.B : In above scripts while starting the BI service it will kickoff IIS and its dependent process first and finally the command window unloaded after invoking iExplore process .Now while stopping the BI service it will forcefully stop IIS and its dependent process like WWW Publishing etc .

Lets find the solution for the same in OC4J Web controller .

OBIEE Start-OC4J.bat

====================================
cd D:\OracleBI\oc4j_bi\j2ee\home
D:
cls
echo “Starting BI ……”
start D:\OracleBI\oc4j_bi\bin\oc4j.cmd -start
sleep 10
net start “Oracle BI Server”
net start “Oracle BI Java Host”
net start “Oracle BI Presentation Server”
start iexplore “http://localhost/analytics/saw.dll?Dashboard&NQUser=Administrator&NQPassword=Administrator
====================================

OBIEE Stop-OC4J.bat

============================
cls
echo “Stopping BI ……”
net stop “Oracle BI Presentation Server”
net stop “Oracle BI Java Host”
net stop “Oracle BI Server”
cd D:\OracleBI\oc4j_bi\j2ee\home
d:
java -jar admin.jar ormi://  oc4jadmin oc4jadmin -shutdown force
taskkill /IM cmd.exe
============================

Only thing you need to know is that for OC4J you need to change the j2ee home directory as per your enviornment settings .

So finally this make life bit easy for me as you are also far away from 2 simple click on two readymade batch file 😀

Customising Graph OBIEE – A Charismatic Gradient Effect


Sometimes we are so bogged down with our business requirements fullfilling so that its pretty easy to forgot about any enhancement from look and feel perspective which sometimes client demands.”Showmanship” is something should not be avoided and thats why there is common terminology called “Good Presentation” . 

Anyway I am bit fond of colors . If you don’t like colors that means somethings definitely will be colorless in your life 🙂 Thats my opinion …

Keeping in my mind , the professional look and feel sometimes I feel crazy to play with colors to see how a graph representation could be made attractive , verbose and charismatic obviously considering the business fulfillment.Most of them given below adopted the customised gradient effect …

So here you go ….

 Style Graph-2

 

Style Graph-3

 

Style Graph-4

 

Style Graph-5

 

Style Graph-6

 

The above all is the output after tweaking the gradient effect in the PCXML file .You need to edit the PCXML files typically resides at : ..\OracleBI\web\app\res\s_oracle10\popbin) and (..\OracleBI\oc4j_bi\j2ee\home\applications\analytics\analytics\res\s_oracle10\popbin). Considering s_oracle is your default Style for dashboard .Then restart the BI Presentation server, BI Javahost service and OC4J .Sometimes you need to clear your “browser cache” also .

Here I modified below files for the special effect:

bar.pcxml file (for Horizontal Bar Chart) as:

<Chart Version=’4.30.00′ BorderType=’None’ Width=’491′ Height=’295′ BGGradientColor=’#ccccff’ GradientType=’RightLeft’>

column.pcxml (for Vertical Chart) like:

<Chart Version=’4.30.00′ BorderType=’None’ Width=’491′ Height=’295′

BGGradientColor=’#C1FFC1′ GradientType=’BottomTop’ >

Line.pcxml (for Line chart) like:

<Chart Version=’4.30.00′ BorderType=’None’ Width=’491′ Height=’295′

BGGradientColor=’#FFE1FF’ GradientType=’TopBottom’ >

Linecolumn.pcxml (for Line Bar Combo chart) like:

<Chart Version=’4.30.00′ BorderType=’None’ Width=’491′ Height=’295′

BGGradientColor=’#CAFF70′ GradientType=’BottomTop’ >

Pie.pcxml (for Pie Chart) like below:

<Chart Version=’4.30.00′ BorderType=’None’ Width=’362′ Height=’318′

BGGradientColor=’#FFC1C1′ GradientType=’BottomTop’ >

As mentioned possible Gradient types are:BottomTop,TopBottom,LeftRight and RightLeft .