Hi Friends, Today’s topic is a rather common one and could be found on most of the blogs. After a long time, I again implemented the same so thought of sharing it with all. Most of the BI projects have numerous dashboards and the business owners want them to get displayed in a list form [...]

Hi Friends, Sometime back I posted about clearing the prompts while navigating between the Dashboard pages. In that post I mentioned about modifying the instanceconfig file and adding the below tag : <PersistPageState>FALSE</PersistPageState> The only drawback with the above method is that it has an Application wide impact. This means that once we update the instanceconfig file, it will [...]

Hi Friends Few days back I got a requirement from one of my friends according to which he wanted to have the value of  Presentation Variable(selected from prompt) being passed amongst the underlying Multi Select prompts on the Dashboard. Requirement: Each national Promotion have NP Relase date and NP End date ,so, the requirement is to [...]

Hi Friends, I was working on a requirement some days back wherein I had to restrict the number of records in the Pivot table on a page. Firstly, I started to look for Pivot properties but when i didn’t get anything then i used this approach. Follow the below steps to achieve the same: 1) [...]

Hi Friends, Yesterday, I was working on some issue and had to make use of Rank and Dense Rank in some reports in OBIEE. Here I am sharing the same with you as I think this might help some of you. First of all lets understand what is Rank and Dense Rank. Let me explain [...]

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, 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 [...]

Hi Friends, There are many times when the clients ask for landing to a particular dashboard instead of the default My Dashboard. I came across this request too. So what i did is explained below. There are basically some approaches to it. 1)  Go to the settings -> My Account and set the Default Dashboard [...]