Basic External table authentication with password encription

Hello Today, I want to talk about some real basic stuff in OBIEE 10G, which is external table authentication. I know there are many similar posts out there on the internet, I still want to post my own version. This is not to show off or anything, just so I don't have to memorize these things in the future if the article is kept in my own space. I know that we are talking about 11G nowadays, everybody is talking about cool things they can do with...

Read More

OBIEE The application of creating sub-report to filter another report

Hello guy In the creation of OBIEE, we all know that we can use 1 report's result set as filter condition for another report. This is called sub-report, the equivalent SQL statements from the log is then nested query. Today, I want to talk about 1 good situation where this technique can be very helpful. Now look at the below report. This report provides a lot of PWE ID from the left. Now, I want to create another report, the second report...

Read More

How to report data dynamically based on user's personal time zone setting -- Part 3

So from the last time I took a step further to solve the issue of reporting based on time zone, although it wasn't 100% correct, at least it opens up a few options. The conclusion there was that we need to find a way to dynamically choose the time zone offset value and use it for our time conversation. Where I was stuck was at the daylight saving changes that happens from all over the world. Therefore, I have decided to introduce a time zone...

Read More

How to report data dynamically based on user's personal time zone setting -- Part 2

The previous entry has concluded the problem with implementing reports based on different time zone, this time we will proceed with the possible workaround. One thing we have realized is that, the time stamp being displayed on the report is changing according to the user locale, this means it occurs per user session. We definitely should take advantage of such feature, now we have to figure out a way to capture the time zone offset value for each...

Read More