Oracle Business Intelligence 12c: July 2015

Friday, 31 July 2015

Rename Apply / Reset button in OBIEE prompts

If you ever wondered to change or rename Apply / Reset buttons on OBIEE dasboard prompts, here's the way.

Go to the following path on your box,

C:\Oracle\Middleware\Oracle_BI1\bifoundation\web\msgdb\l_en\messages

At this location, you will get all XML files that OBIEE uses to throw messages/errors that in human readable format. For instnace, pick the file viewmessages.xml

Here you wil get all the messages or defauls strings that we see in day-to-day things (like Apply, Reset, Reset, ViewDisplayError, NoRows, etc) in OBIEE.

Change the below tag for renaming Apply button,

Default one:
<WebMessage name="kmsgEVCPromptApply"><HTML>Apply</HTML></WebMessage>

Change it to,
<WebMessage name="kmsgEVCPromptApply"><HTML>Go</HTML></WebMessage>

That's it. Just bounce your services to load all the modified configuration files. You in with Go..!!

Happy stay.!! :-)

Hide BreadCrumbs in OBIEE 11g

There might be a requirment like, you need to hide breadcrumbs on your dashboard or reports. To achieve this, obviously you need deal with some css files. Here we go

There are files common.css you can find on below mentioned paths.
Location:
C:\Oracle\Middleware\Oracle_BI1\bifoundation\web\appv2\res\s_FusionFX\b_mozilla_4\common.css

From below path, select the skin you are using.
C:\Oracle\Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res

My skin is, s_blafp so my path would be,
C:\Oracle\Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\s_blafp\b_mozilla_4

Find .breadcrumb tag thoughout this file and add "display:none;" (without the quotes) (You probably have total 11 breadcrumb tags in this file) :-P

For sample, one of your tag will look like this,

.BreadCrumbDiv{width:100%;border:none;background-color:#DEEAF1;margin:-7px 0 0 0;height:22px;display:none;}

PS: Changing a CSS files in the default OBIEE folder, is NOT a recommended method at all. Instead create a Custom StyleSkin from existing one and you are ready to make plenty of all possible changes throughout your CSS world. If gets failed, switch back to defaul one. ;-)

The reason this is not recommended is,

You change a CSS file in the default OBIEE folder, you are happy with your changes, that's fine.
4 months later somebody patch your OBIEE to fix some bugs or security issues and surprise: your changes disappeared, they are gone.

So you go back and change the CSS file again after having your users complaining with you first that things changed. 3 weeks later another patch is applied and guess what? Again, you lost your changed and you have to apply all these things again.

Now, if you only set the "display:none" for a single class or ID it's 1 line to change, but as you started in that way you will probably change other things, in the end you have a list of 10-20 things to change. The first time you still remember everything, the second time you forget to change 3 lines of the 20, the third time only half of the changes etc.

Happy bloggin..!!