OBIEE: Where'd my SQL Go? Part II
Back in July I wondered where my SQL went when I deployed an opaque view to the database.
I found it.
Recently, I was introduced to a person at the client site I'll just call The Process Queen™. I had written some code (pipelined table function) that was to be deployed to the database, she was
making helping me get it into SVN and showing me how they deployed code. The Process Queen™
In that regard, I wanted to get everything that we could into SVN. Those opaque views (now deployed as database views) were a perfect candidate.
The client impressed me with their deployment tools, I hadn't seen anything like it. I wish I could say more, of course...perhaps I can talk The Process Queen into a guest post?
Anyway, so there I was, following my own guide
Where'd My SQL Go? and then I noticed this
and this.
Notice those SQL statements are different. Apparently in OBIEE you can add a SQL statement in to each and every database type that you want.
An interesting, if not scary, find. Which begs the question, why would you need this kind of functionality?
Labels: obiee
