OBIEE 11g RCU Meta Data Change

Every one aware RCU is mandatory to install OBIEE 11g.When we install RCU it creates two schemas

1.       DEV_BIPLATFORM (Used by Weblogic and OBIEE)

2.       DEV_MDS (Used by Weblogic)

If you want to change the metadata repository of RCU to some other database due to various reasons, we can change the RCU repository metadata from one instance to another instance without impacting the current installed OBIEE11g environment. Below are the detail steps.

Login to Weblogic Admin Console 

Navigate to Services >> Datasources

Click on bip_datasource and click on connection pool

  

Click on “Lock & Edit” button

Update the following information like host name, instance and password as shown above and do the same for all data sources (EMPsystemregistry, mds-owsm), save and “Activate changes”.

  

Login into Enterprise Manager

Go to Business intelligence folder >> coreapplication >> Deployment  >> Scheduler

Click on “Lock and Edit Configuration“, update the datasource details. “Activate Changes” ,  and click on “Restart Services” .

 

 Try this it works...

Custom Back button - Opening report in same window

When you create a dashboard and you have a drill down report the drill down report opens in the same window. So when you hit the return link the drill down report also closes. Thats fine a back button can be placed in the answers request also when there are No Results a custom no results page can be added to look exactly the same but with a back button too.

Insert a static text box "contains HTML Markup" into answers request.

<table align="left">
<tr >

<td>

        <a href="javascript:history.back();">Back</a>

</td>

</tr>
</table>

Try this..It works.

Modifying the Colors Available in a Chart

In OBIEE 10g it was possible to set the color attributes for a chart by modifying palette.cxml file.How can you do this in OBIEE 11g?

Edit following file
<Oracle_BI1>\bifoundation\web\msgdb\s_blafp\viewui\chart\dvt-graph-skin.xml
Add lines after </SliceLabel> to specify the colours.  Here is an example giving a range of colours:

<SeriesItems>
<Series id="0" color="#4a9cd9" borderColor="#4a9cd9"/>
<Series id="1" color="#f68e55" borderColor="#f68e55"/>
<Series id="2" color="#a4aadc" borderColor="#a4aadc"/>
<Series id="3" color="#ffff66" borderColor="#ffff66"/>
<Series id="4" color="#99cc66" borderColor="#99cc66"/>
<Series id="5" color="#9de3f9" borderColor="#9de3f9"/>
<Series id="6" color="#dbacf3" borderColor="#dbacf3"/>
<Series id="7" color="#cc6699" borderColor="#cc6699"/>
<Series id="8" color="#886ecc" borderColor="#886ecc"/>
<Series id="9" color="#fac969" borderColor="#fac969"/>
<Series id="10" color="#1cc1f5" borderColor="#1cc1f5"/>
<Series id="11" color="#ccff99" borderColor="#ccff99"/>
</SeriesItems>

Refer the below link for Hex code.

http://hareeobiee.blogspot.in/2012/12/html-color-hex-codes.html
 
 

This way you can modify the colors for chart. Try it out.

" No Result " Custom message with Information icon

To get " No Result " Custom message with information icon like the following image,

Go to results tab, click Edit Analysis Property icon and place the below text in messages section.

<table cellspacing=0 width="300" ><tr>
<td class="ErrorTitle" valign=top ><img src="res/sk_blafp/common/title_info.png">&nbsp;</td><td class="ErrorTitle" align=left>No Results</td></tr><tr>
<td>&nbsp;</td><td class="ErrorInfo">The specified criteria didn't result in any data.<span style="font-size: 6pt;"><br><br></span><font point-size=4><br></font></td></tr>
</table>
<style type="text/css">
td.ResultLinksCell {
display:none;
}
</style>

Try this, It works.

OBIEE11g Report Logo’s

OBIEE has some nice default report logo’s. Problem is you don’t always have access to the directory to browse them. Here is a Cheat Sheet:

Moving View Selector to Left Side in OBIEE 11g

Need to add

VSelSelector{padding-bottom:2px;text-align:left;}. line in views.css file from the below mentioned paths.

E:\Middleware\Oracle_BI1\bifoundation\web\app\res\s_blafp\b_mozilla_4\rtl\views.css

E:\Middleware\Oracle_BI1\bifoundation\web\app\res\s_blafp\b_mozilla_4\views.css

E:\Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\s_blafp\b_mozilla_4\rtl\views.css

E:\Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\s_blafp\b_mozilla_4\views.css

Save the files and restart OPMNCTL then we can see View Selector changes to the Left from center.

Get the previous row value in OBIEE 11g

Way of getting a value of the previous row: Use MSUM (MovingSum)

Actuals: "MCSR"."Actuals PJTD"

Previous Actuals:  MSUM("MCSR"."Actuals PJTD",2) - "MCSR"."Actuals PJTD"

Try this.....