Missing "Treat Text As" options in OBIEE 11g

Something I used to use back in OBIEE 10g was the Override Default Data Format for text to do things with HTML in my Answers Requests. I had assumed this would be available the same way out of the box with 11g, but alas it is not.

What I get:	What I want:

So as always, I did a little digging, and found that in order to have all options show, you need to have the privilege: Save System-Wide Column Formats. What's even better is that out of the box, this privilege is assigned to no one, so you can't even set it!

Continue on to read what I did to allow me to enable the setting for BI Administrators, and finally gain access to all the treat text as options.

Scripted OBIEE 11g Web Catalog deployments using runcat.sh and WLST

I had never looked deeply into automating the OBIEE Web Catalog, as on previous engagements I had a technical architecture team which handled all deployments. They were used to doing a manual process utilizing the Catalog Manager. On my latest engagement, I am the technical architecture team, and I like automation.

After poking around, I found that you can call the catalog manager form the command line, and along with WLST scripting, you can do a fully automated web catalog deployment.

After the jump is a script which can be used to do OBIEE 11g web catalog deployments. This script assumes you have setup ssh keys on the various servers so you can login without typing a password (http://www.linuxproblem.org/art_9.html).