BINS/Groupings not working with prompts

BINS in OBIEE do not work with dashboard prompts even if you copy the exact case statement from the original report in which you created the BINS. Solution: Create the bins, once OBIEE create the case statement go ahead and clear all bins but leave the case statement in place. Then copy that case statement as a function in your prompt. Now your dashboard prompt should work.

If this post helped you, then please leave me a comment below.. :)

Changing Column Width in OBIEE

I had an issue where my column width just would not change even after I changed the properties of the column. OBIEE doesnt allow changing column width of a varchar column so I had to go back to the RPD and change my column width to LONGVARCHAR. Worked like a charm :)

Hope this helps!!!

Embedding an External Site within OBIEE Dashboard

Here are the steps to embed an external site within OBIEE. Its super simple!

1. Go to your edit dashboard page

2. Drag 'Embedded Cotent' dashboard object on the left to your dashboard

3. Enter the URL of the site to embedd and set the width and height properties

4. Click 'Ok' and save your dashboard
5. Final dashboard page will look like this

OBIEE - Refresh Button for Single Report

I need to add a  Refresh link at the top of the OBIEE report rather than have the user scroll all the way to the bottom each time they need to refresh. Here are the steps to create a refresh button at the top of the page.


1. Open the OBIEE dashboard that contains the report to refresh in either firefox or chrome browsers. If your using Firefox, you will need to have firebug installed. For chrome users, click CTRL + SHIFT + J (I will be using Chrome for my instructions)

2. Click the 'Element' selector button. Then click the 'Refresh' button on OBIEE report to view the code

3. Right click on the code and select 'Copy as HTML'

4. On your OBIEE dashboard, paste this text into at text field. Be sure to check 'Contains HTML Code'  check box

5. Click 'OK'. Save your dashboard and you should see the 'Refresh' link on your page.

Hope this helps! Please leave me any feedback or questions you have.

Working with Excel on Multiple Screens

If you are using 2 monitors and would like to work on multiple Excel documents, you need to open up separate instances of excel. It will not work if you just open the documents in the same excel window. Try opening each separately, so go to start->Programs->Excel for each file. This will allow you to drag the separate instances of excel to any monitor you choose. It may seem like a simple issue but if you don't know how to resolve it, it can be extremely annoying.