Tag Archives: OBIEE 11g
OBIEE 11.1.1.6 upgrade guide
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!
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
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:
Put it all in a pivot view:
Check the results:
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
In the related items part drag the Causes, Effects and Intiatives
In Scorecard Documents select Create Cause & Effect Map
Drag in the objective you want tot process.
And save the map.
An other feature is the Strategy Map.
Strategy Map:
Scorecard documents >> Strategy Map:
Drag you main objective to the map
Select Add Related Strategy Nodes:
Rearrange them and add extra dependencies
Till Next Time