Hi Frens, Sorry to keep you waiting  for the next post, but here it comes. Previously, in the second segment we have discussed the Presentation Server and the Presentation catalog. So, lets continue with the third segment where we will see what is the role of the BI Server in the OBIEE Architecture. BI SERVER [...]

Hi Friends While working with OBIEE for a long time I came across some Basic Unix commands which can be used while performing some admin taks like uploading the repository etc. So i thought of sharing the same with you….. Below is the lost of the commands and their brief description: . – specifies the [...]

Hi Frens, Sorry for the delay as I was busy in some assignments of mine which had to be taken up on priority. Today we changed the Administrator Password for OBIEE, BI Publisher and Scheduler so, thought to share the same with you. We can change the Administrator password by using the following steps: 1) [...]

 MERGE JOIN: Oracle performs a join between two sets of row data using the merge join algorithm. The inputs are two separate sets of row data. Output is the results of the join.  Oracle reads rows from both inputs in an alternating fashion and merges together matching rows in order to generate output. The two [...]

Many a times we come across a requirement to provide the users with a button on the Dashboard which will clear the values selected in Prompt. We can do this by a bit a scripting, lets see how we can achive this. To achive this first we need to create a button and then call [...]

Hi Frens, In the previous post we were studying the architecture of OBIEE, so, lets continue with it. We have divided OBIEE Architecture in 4 segments to better understand it. 1) Client and User Interface 2) Presentation Server & Presentation Catalog 3) BI Server & Admin Tool 4) Datasource We have covered the first segment [...]

Hi Frens, I am sorry that I engrossed myself in posting some complex stuff and left the Basics in between, so, here I am again with the Basics of OBIEE. In our previous posts we have covered Data Modelling, Basics, Connection Pool, Joins etc. So, lets start to build more on that and lets go [...]

Hi Frens, Again came up with a new requirement and thought of sharing the same with you. My client asked me to wipe out the selected values in the Dashboard prompts when he navigates from one page to another on the dashboard. So, finally I found the following solution for the same. We need to [...]

Hi Frens, Here I m back again… This time i have got a real nice thing with me ‘Hovering text in OBIEE columns‘. This requires HTML or Javascript coding in OBIEE column headers which is not permitted by default OBIEE config. So, to enable it, we need to insert the following tag in instanceconfig.xml file. [...]

Hello, Day before we came across a new requirement in which we had to call a function created in Oracle DB to OBIEE. Thought of sharing the same with you. It is very simple if you know the trick. We made use of the EVALUATE function in OBIEE to call the function created in the [...]