OraNA :: Oracle News Aggregator

I recently was asked about the different options of visualizing data in OBIEE on maps. Since many of the usual suspects (you'll see form the link-list below) have already blogged about this, it is easiest to provide a list with all good and informative articles rather than writing a completely new post. Here goes:

Google Maps:
www.artofbi.com:
http://www.artofbi.com/index.php/2009/07/obiee-and-google-maps-integration/

John:
http://obiee101.blogspot.com/2008/10/obiee-using-google-maps-q-style.html

Oracle Mapviewer / Oracle Spatial:
Venkat:
http://oraclebizint.wordpress.com/2007/09/25/oracle-bi-ee-10133-and-mapviewer-step-by-step-integration-phase1/

Gerard:
http://gerardnico.com/wiki/dat/obiee/presentation_service/obiee_dynamic_integration_oracle_map_nsdp

Lapp, Conrad & Sharma (OOW 2008):
http://www.oracle.com/technology/products/mapviewer/pdf/mapviewer_obiee.pdf
Abhinav (OOW 2008):

Maarten (RittmanMead Forum 2009):
http://www.rittmanmead.com/files/maarten_jan_kampen_obiee_mapviewer. (more...)

A while back our oraclenerd had a question about presentation server cache settings which he sent out through twitter.



rnm1978 and me answered to his distress call (emails not included. twitter's quite useless for sending instanceconfig.xml subsets ;-)).



However, I wanted to make it clear through this post, what part of the presentation server cache is actually managed by which parameter since there's a little gotcha in there.
So basically we there are four parameter which exist for the presentation servers instanceconfig.xml (see also Johns pdf extract). By default they're not explicitly noted in the file so (more...)

A question which I never covered in my blog yet since it was too basic and should normally work at all times when you import an Essbase cube:
How do I get a fact to display in the BMM layer after importing a cube?

The question came up here and basically has its origin in a bizarre cube outline. Correctly defined cubes will never face this (and hence no one covered it yet, though I already spoke about changing the measure hierarchy).

Let's look at an import without a working "fact" (in OBIEE terms...).



No fact columns...but (more...)

During the day I realized that MOS was acting strangely since I upgraded to FireFox 3.6 and @rnm1978 confirmed my findings just now:
You can't directly read MOS knowledge items with Firefox 3.6

Opening a knowledge items as usual (left-click - which should display the content on the right hand side of the screen) just pulls up a blank display:



You have to right-click the item and choose "Open Item in New Window" to see its content.



Not very comfortable but there's always supporthtml.oracle.com as a fallback scenario.

Cheers,
Christian

First of all a little disclaimer: No, I haven't died in the meantime. Other topics took precedence over writing blog posts.

Back on track, I recently received a question from Jeff Tam who also works on a hybrid OBIEE-Essbase solution. Funny enough, jsut this morning there was another question on this on the OTN OBIEE forum here. Basically being a follow up on my post here botg JEff and the poster on OTN wanted to know the detailed steps which are to be taken to manually extend dimensional hierarchies of already imported Essbase outlines in the RPD. Oracle has their (more...)