Tag Archives: OBIEE 11g

OBIEE 11.1.1.6 upgrade guide

Upgrade guide is found here:

http://docs.oracle.com/cd/E23943_01/bi.1111/e16452/bi_plan.htm#BABECJJH

Pretty much a standard weblogic upgrade.

Till Next Time

OBIEE 11.1.1.6 is out!

If you have missed it:
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html ==> 11.1.1.6.0 is out
See the nice new features:
http://docs.oracle.com/cd/E23943_01/bi.1111/e10540/whatsnew.htm#CJAEEGJH

Till Next Time

OBIEE11g FireFox 10 problems

For those of you having problems with the new FireFox 10 client. Michal Novy posted a solution on Christians Blog:

Hi, I found the way how to do a workaround:
1. type "about:config" into an address bar
2. right click anywhere and choose New / String
3. name it "general.useragent.override"
4. put the value "Mozilla/5.0 (Windows; Windows NT 6.1; rv:10.0) Gecko/20100101 Firefox/9.0"
5. refresh OBIEE login screen
Then it works without any problems!

Seems that Oracle is already working on some patches: see patch # 13564003 released by Oracle Support which repairs this limitation.

Till Next Time

OBIEE Calendar Control

image

Question from the OTN Forum. (Works in 10 & 11g)

Select a YearMonth, YearWeek and Date from your Calendar dimension, select a measure from your facts.

Add a extra column called “Day Of the Week”

CAST(DAYOFWEEK("Time"."T00 Calendar Date") as varchar(2)) || ' - '||DAYNAME("Time"."T00 Calendar Date")

Alter your fact column to:

'<b>'||cast("Time"."T00 Calendar Date" as varchar(10))||'</b>'||'<br><P STYLE="text-align: right;">'||CAST("Base Facts"."1- Revenue" AS varchar(15))

It concats the date with the fact and adds some HTML Formatting

Alter the column properties [data format] to HTML:

image

Put it all in a pivot view:

image

Check the results:

image

Till Next Time

OBIEE11g Scorecarding Part 6

Look here for:

  • Part 1 Vision Document
  • Part 2 Mission Statement & Perspectives
  • Part 3 Watchlist & Objectives
  • Part 4 Goals & Startegy Tree
  • Part 5 Startegy Tree Assesment Formula, Initiatives

Besides the strategy tree OBIEE offers the possibility to create and Cause and Effect or Fishbone chart.

Cause and Effect chart:

Go to your strategy objective

image

In the related items part drag the Causes, Effects and Intiatives

image

In Scorecard Documents select Create Cause & Effect Map

image

Drag in the objective you want tot process.

image

And save the map.

An other feature is the Strategy Map.

Strategy Map:

Scorecard documents >> Strategy Map:

image

Drag you main objective to the map

image

image

Select Add Related Strategy Nodes:

image

Rearrange them and add extra dependencies

image

Till Next Time