Passing special characters in Oracle BI EE

I saw a question on Oracle IT Toolbox the other day. A subject which I mentioned this earlier.

Passing special characters in Oracle BI EE is something you should avoid as much as possible. If you have to cope with these special characters, eg. in a GO-url, please refer to a site which handles HTML URL Encoding; http://www.w3schools.com/TAGS/ref_urlencode.asp

If  you have a string with spaces, you could use the ‘REPLACE’-function to substitute the space with; ‘%20’. If necessary you could nest the ‘REPLACE’-function to also substitute ‘&’ with ‘%26’.

Something like; REPLACE(REPLACE(string, ‘ ‘, ‘%20’), ‘&’, ‘%26’)

Good Luck

Changing Colors

One of my clients wanted to change to color fromat of the grand-total columns in a Pivot-view. The format of values of the grand-total should match the format of the label of the grand-total. I used to go to one of John’s blogposts; OBIEE views.css color cheat sheet. One of my colleagues pointed me to the color picker functionality in Paint.Net, although there are probably more programs with such functionality.

How does it work? Picture the following pivot;

Make a screenshot of this pivot and open it in Paint.Net. Open de colors-window (F8)

Click on the color-picker in the tools-window.

Use the color-picker to select the color you want to use. In this case I had to click on the grand-total column. Now when you check the colors-window, you get exactly the color codes you have to use to change the format of the grand-total values.

Very easy to use, but yet very handy.