Home | Ciber
Knowledge page of Ciber Netherlands

Archive for March, 2009

OBIEE Google Maps Multiple Addresses

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:

image

Now create a narrative view:

image

Read more

No comments

OBIEE date prompt to day month year

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

No comments

Forum Autorefresh

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

No comments

OBIEE identifying the hierarchy level

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:

image

Read more

No comments

Find the differences

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.

clip_image002

Read more

No comments

OBIEE Custom Authenticators

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

No comments

OBIEE NQSSetSessionValue

image

 

Read more

1 comment

OBIEE Date, TimeStamp and ORACLE Indexes

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

No comments

OBIEE Between Dates Prompt

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:`

image

Read more

3 comments