Based on a previous posting (http://obiee101.blogspot.com/2008/10/obiee-using-google-maps-q-style.html) on my personal blog I was asked if it’s possible to add multiple addresses to a Google map. Actually this even simpler then having to create a separate map for each address.

Let’s get our base table:

Now create a narrative view:

Read more

A Obiee prompt from a calendar to a presentationvariable is cast as date. One way of extracting the day, month or year can be done based on the locate function:

day: substring( ‘@{Date1}{01/01/1900}’ from (locate(’/',’@{Date1}{01/01/1900}’,1) +1)for (locate(’/',’@{Date1}{01/01/1900}’ ,4) - locate(’/',’@{Date1}{01/01/1900}’,1)-1))

Read more

I’m a hugh fan of the OTN fora. Problem is that it doesn’t have an auto-refresh. I’ve made a small script to load the page in a iFrame and reload it every 5 minutes:

<!– OTN OBIEE With autorefresh –>
<!– Check if it’s a 5 minute part of an hour is reached –>

<script type="text/javascript">
  var timer = setInterval("checkTime()", 1000 * 60 );

  function checkTime()
  {
    if((new Date().getMinutes() % 5) == 0)
      self.location.reload(true);
  }
</script>

<!– Load the page as Iframe –>

Read more

On the OTN forum I was asked how you can identify the hierarchy level which the user is currently on (Did he select Year, Quarter,Month etc?).

One way of doing this is "using" the aggregate awareness availability of a column. First you create a "dummy" aggregate view for each hierarchy:

• year_level: select distinct d_year, 4 AS DIM_LEVEL from d_date
• quarter_level: select distinct d_year, 3 AS DIM_LEVEL from d_date
• etc.

These tables you physically join to your dimension:

Read more

Remember the puzzles where you should find the differences between two pictures? To some it looks like the same applies, on a very high level, to SRM and SNC. Both can be used for purchasing, both support a form of supplier self-service and both … Read the full article to find out all differences.

Read more

Within OBIEE you can build your own custom authenticators. In the directory {OracleBI}\server\SDK\CustomAuthenticatorSamples\ you can find a sample. But if you are just like me not up to speed C++ it takes some effort to get it working.

Step 1: get a C++ compiler. (I used the Microsoft Express edition)

Read more

Read more

Mark Rittman triggered meto investigate this: If you are Filtering against a date column in OBIEE you will see in the log that a timestamp conversion is added to your query:

select distinct T2826.DAYTIME as c1
from
     DAYTIME2 T2826
where  ( T2826.DAYTIME = TIMESTAMP ‘1968-03-14 00:00:00′ )
order by c1

Read more

One the questions you see regularly on the forums is how to create a ‘between dates’ dashboard prompt if the date column is not a part of a date dimension. If more important with the use of the calendar control.

Step 1 create a new prompt based on a date dimension:`

Read more