Social Icons

Tuesday, October 23, 2012

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.. :)

Friday, October 5, 2012

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!!!