Query hints in OBIEE

Uli Bethke April 5, 2009

I have recently come across a post on the OTN forums on how to use hints in OBIEE. OBIEE lets you specify hints in the physical layer on a table by table basis. The problem of the user in the forum was how it is possible to hint the alias of a table in the ...

Read More

Consuming a REST web service with Oracle

Uli Bethke March 12, 2009

SOAP web services dominate in a SOA environment. However, there is a new kid on the block: REST. This is a more lightweight approach to exchange data over HTTP, which is becoming more and more popular with web mashups and the web 2.0 in general. Amazon, Twitter, Yahoo all expose their APIs via REST. REST ...

Read More

It's the tool, stupid. Or is it?

Uli Bethke March 3, 2009

Every couple of months or so, they run an article on Business Intelligence in one of the Sunday business papers here in Dublin. The tenor of these articles goes like this: Just pick the right BI tool, sit back, and relax. It will all sort itself out. This reminds me of the Fast = On ...

Read More

Date dimension script with Oracle SQL

Uli Bethke February 24, 2009

The script below will create a date dimension in just one SQL statement. We don’t use performance-killer nonsense such as cursors, functions etc. We just pick a start date and the number of days we want to create and with a bit of magic of the Connect By clause and the NUMTODSINTERVAL function we do ...

Read More
1 76 77 78 79 80