Download Excel Calculator for Salary Components – Save Income Tax!

by

Hello Readers,

I have attached a plain and simple excel sheet with some basic calculations. These are the most easily usable components in salary. There are other components such as Meal Coupons, Uniform Allowance etc, but all these other components might get difficult for smaller companies.

salary-component-breakup

In the attached excel, just enter the CTC amount and rest will be done! If you want you can play with the field values to suit your situation. DON’T FORGET to get it checked from a CA or finance guy to be full proof. I just did this in my free time so thought of sharing. Use it or ignore it 🙂

I do NOT intend to cause any trouble to anyone.

 

Best Regards

Remove header area from OBIEE11g Sign In and Sign Out Page

by

Hi All,

After a lot of head banging and finally after getting help from Svee from OTN, I was able to remove the header box from both, Sign In and Sign Out pages.

The logcontrolmessages.xml file needs to be tweaked.

File Name: logoncontrolmessages.xml
File Location: C:\obiee11g\Oracle_BI1\bifoundation\web\msgdb\messages\logoncontrolmessages.xml

The above mentioned file has 3 entries for table in the following format:

Just remove the first line i.e. erase the line 

> and the header area will get removed.

For your own knowledge, you can try and play with the contents of this file to see the changes. But make sure to backup this file before making any modifications.Happy obiee11gING…

Thanks n Regards

OBIEE11g – Sections are expanded by default.

by

Hi,

In my case:
1) There we no saved customizations for any report. Still by default the sections were expanded.
2) I saved a customization for a particular report for e.g. Test01
3) Then I stopped the BI services and went to the following location:

C:\obiee11g\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\RiskConcierge\root\users\administrator\_selections\

4) In the _selections folder search for Test01. You will find two files with that name. First one will be Test01 and second one will be Test01.atr.

5) Open the first one in notepad and then search for the following:

xsi:type=”sawst:section”.

6) I added minimized = “true” to the above line.

7) Thus the above became the following:

xsi:type=”sawst:section” minimized = “true”.

8) Save and close the file.

I did this for every entry of section which I wanted to show collapsed by default. Saved the file. Restarted the services. The section is fixed now !! Its not expanded anymore.

Thanks n Regards

Some useful OBIEE11g Customization

by

Hi All,

I have recently moved to OBIEE11g and am learning the hard way. I am facing issues almost every day and am able to solve most of them with the help other forums and also little bit with my own experience. I have made a small list of customizations in OBIEE11g. Hope it helps.

NOTE: The following solution has worked for me and thus I have posted them.

For custom skin related queries, I would request you all to just follow the steps mentioned in the following link:

http://www.rittmanmead.com/2010/12/oracle-bi-ee-11g-styles-skins-custom-xml-messages/

The best content on the internet and it works !

Now, coming back to my initial experiences with OBIEE11g, please read on:

———————————————————————————-
> Edit the “Thank you for using” text in the logon page….
———————————————————————————-
* File Name: productmessages.xml
* File Location: C:\biee11g\customMessages\l_en\messages\productmessages.xml
<*> Edited the line

NOTE: biee11g is the folder I created using the above rittmanmead link.

———————————————————-
> Change dasboard background color….
———————————————————-

* File Name: common.css
* File Location: C:\biee11g\sk_administrator\b_mozilla_4\common.css

<*> Edited background-colour in .HTMLBodythe file common.css in C:\biee11g\sk_administrator\b_mozilla_4 with the following:

1) .HTMLBody{font-family:Tahoma,sans-serif;font-size:11px;background-color:#FFFFFF
2) .HeaderContainer{background-color:#FFFFFF;

Replaced the existing color code i.e. #0D4988 with #FFFFFF

—————————————————-
> Change dashboard header logo….
—————————————————-

<*> Replaced the oracle_logo.png file with your customized logo image in the following two locations:
1)C:\biee11g\sk_administrator\b_mozilla_4
2)C:\biee11g\sk_administrator\login

————————————————————————–
> Change copyright info on dashboard login page…
————————————————————————–

* File Name: utilmessages.xml
* File Location: C:\biee11g\customMessages\l_en\messages\utilmessages.xml

<*> Edited the following two lines as per requirement:
1)
2)

——————————————————————-
> Change login text on dashboard login page…
——————————————————————-

* File Name: logonmessages.xml
* File Location: C:\biee11g\customMessages\l_en\messages\logonmessages.xml

<*> Edited the foll lines as per requirement:
1)
2)

————————————————————————————
> Remove Help and About Product link from sign in page…
————————————————————————————

* File Name: logonmessages.xml
* File Location: C:\biee11g\customMessages\l_en\messages\logonmessages.xml

<*> For removing Help link, just remove the text “Help” from the following line:

<*> For removing About link, just remove the text “About Product” from the following line:

—————————————————–
> Reroute Home link to custom url…
—————————————————–

* File name: header.js
* File Location: C:\obiee11g\user_projects\domains\axslogic_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\b_mozilla\header.js

<*> Look for the foll:

saw.header.NavBar.prototype.onHome=function
(b,a)
{saw.header.openURL(saw.commandToURL(“bieehome”),
a)}
saw.header.NavBar.prototype.onHome=function
(){window.location.href=”http://www.mywebsite.com&#8221;}
Before

Just replce “bieehome” in the above code with the url of your choice. The new code looks like the following:
saw.header.NavBar.prototype.onHome=function
(){window.location.href=”http://:9704/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2FAnalyst%2F_portal%2FMy%20Dashboard&page=My%20Page&#8221;}

Thanks n Regards