Lake Minneola Half Marathon 2013

4:30 a.m. – It is dark.  Alarm goes off.  It has been raining all night. Awake for half an hour, I’ve been thinking of the day about to start.  Having picked up running five months ago hoping to improve my health, today was going to be different.

I had registered to run my first half marathon, Lake Minneola’s Half Marathon.

2013 lake 12k - 640

Continue reading

Hungarian Bookshelves

So after reading this post http://toolmonger.com/2012/03/28/hungarian-shelves-ftw-or-why-tm-readers-rock/ about bookshelves, I was naive enough to give it a try.  This is my brief overview of how in went for me, in pictures.  I’ll be happy if it saves a few people a few hours or headache or two.  I am not apologizing for the phone pictures.

Notes of value follow each picture.

Image

Here’s finished shelf.  The stain has almost dried, can still smell it.  I blink, its half way full already!

Continue reading

Saving OBIEE RPD As XML Content

One of the many benefits of working at Oracle is access to Oracle University.  I just found out about this new feature in a recent class I was able to take.

With the release of OBIEE 11.1.1.6, Oracle now provides basic SVN integration in Admin Tool.  It seems Oracle is moving away from storing RPD content as a binary file (wishful thinking).  I think this is a step in the right direction and would like to be able to merge and diff RPD work from Admin Tool or versioning system of choice.  I am assuming SVN integration in Admin Tool is just as good as in SQL Developer Data Modeler Winking smile.  Just like Data Modeler, you still have the option of not enabling SVN integration and using your versioning system of choice.  This is what I am going to do.  It gives me more choice such as which versioning system to use and independence from Oracle’s SVN feature set included in tool which is a subset of SVN anyways.

Continue reading

Data for Good – Hilary Mason @ UrbanRethink May 6, 12

A few Sundays ago, Hilary Mason (bitly‘s Chief Scientist) dropped by UrbanRethink.  UrbanRethink is one of Orlando’s collaborative hubs for artist, hackers and designers to meet and work. On top of that, it keeps a calendar full of events throughout the month.  This was one of those talks.  I need to keep a better eye on their events calendar.  This talk was great.  Hilary talked extensively about ‘Data for Good’.

Many of the ideas and topics covered were notable to me.  Here follows some of the more worthy ones. 

Continue reading

OBIEE RPD Consistency Error – The feature in Database do not match the defaults

Moving development form database to database, I frequently end up with Warning: "OBIEE RPD – The feature in Database do not match the defaults. This can cause problems."  I assume this can be attributed to all these database (and servers) having slightly different settings, defaults, connections properties.  Sometimes I move databases and it does warning does not show up. Sometimes it does.

Continue reading

Auto Start OBIEE With Windows

One of OBIEE’s idiosyncrasies is that, by default, only the user that installed the product can start the server from the Window’s Start menu.  For more information on this, please read this old post.

The solution outlined on that post enables ADDITIONAL users to start OBIEE. This is still borderline unacceptable on a production environment.  Ideally, we want OBIEE to start with the Windows Server.

What we want is OBIEE to start as a service on boot up.  The only original information I’ve found on this comes from Oracle itself.

Everything else ‘on the tubes’ so far is a copy/paste job from Oracle doc.  However, I have found no success stories from anyone.  I could not get this to work either for OBIEE.

This is where Windows Scheduler comes in.  Using Windows Scheduler, I was able to set OBIEE to start on system startup without any trouble. 

Continue reading

Oracle Business Intelligence Enterprise Edition Client Tools

Talk about running behind.  I recently found out that Oracle does offer a client tools ONLY set for OBIEE.  As of this writing (11.1.1.6.0), you can head over here and grab Oracle Business Intelligence Developer Client Tools Installer.

At a bit larger than 300 MBs, this download is a walk in the park compared to them 25 GBs.

I am successfully running Admin Tool now sans server on local box but I ran into a few odd things along the way.

Continue reading

OBIEE–RPD Fails Global Consistency On Joins Between Tables

You finish revising RPD for project and, upon checking global consistency, you get the following error(s):

[38015] Physical tables "<TABLE_ONE>" and "<TABLE_TWO>" have multiple joins. Delete new foreign key object if it is a duplicate of existing foreign key.

Each of these errors points to different tables but they are all of the same type.  Sensibly, error states that the tables in question have more than one join between them. 

Continue reading