OBIEE topics of interest

Good morning All,

I’m back from Florida vacation. What a change – to come from sunny Florida to cold and raining New York.

Trying to see what’s going on in the OBIEE world. Couple interesting topics on the OTN:

Write back – topic – very interesting and growing

Example on how not to ask questions about complex joins – the author should have provided all the details in the beggining

Not using AGO and TODATE functions – I don’t know why anyone would like to avoid using AGO and TODATE functions for time-series analysis. The only two options are: non-Oracle DB which doesn’t support complex PARTITION BY queries or someone doesn’t want to create time dimension.

Also, there’re some very good discussions on the OBIEE Enterprise Methodology Group.

Good luck and enjoy your week.

OBIEE expert forum is up and running

I’m delighted to announce that a new useful OBIEE forum / discussion board is open. Idea was up in the air for a long time – and it seems as multiple people planned this for awhile independently (rnm1978, Mark Rittman, Adrian Ward, and other guys and myself included). Part of it was frustration with moderation on official Oracle’s board, and part of it was a need for a resource where OBIEE and business intelligent professionals could share secrets of the trade. The difficult part is keeping balance between sharing knowledge as well as  providing a moderated environment.

The board is already active with several interesting topics going. If you’re interested in participating – please apply at Google OBIEE group

Thanks to Mark Rittman who organized the movement and to all those who agreed to become moderators.

OBIEE Software Configuration Management


There’re some very interesting blog posts about handling OBIEE’s SCM process, however, the difficulty is that each project is different. For example, there’re so many environmental factors involved – everything depends on location. In some enterprises, they use corporate-wide version-control systems (such as TFS). In some places, they don’t. Some companies have a rigid DEV to SIT to UAT to PROD process, in some companies – such development is done ad-hoc.

Sometimes, webcat is copied manually. Sometimes, it’s merged online. Sometimes it’s archived and extracted.

Myriad options and almost endless number of possibilities.

Sometimes, the RPD is merged locally, sometimes it’s imported, sometimes, it’s done via MUDE projects. Everyone is different and each situation is different. And here’s when experience and expertise come into play – an experienced consultant can provide the best way of handling OBIEE’s deployment process.