Tag Archives: obiee consulting

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.

Problem With Caching A Report in Answers Using A Script

The cache is purged but new cache is not created. Customer is not able to cache the reports which contain Database Functions for Columns.
All the cache entries were not created when used a logical query which contains DB functions in it. The query doesn’t get cached and there is no error
Cache is created when the queries are not using any database functions.


Queries containing the evaluate function are not qualified to cache. Hence this query is not getting cached. This is expected behavior.
Evaluate is not cacheable because there is no reliable means for OBIEE to interpret the semantics of the string function definition and determine if the
function defined there can be reused under what condition. Take a simple example, Evaluate(‘Today()’ as Date), OBIEE would have no idea this function
returns a result that can be reused till the end of day.

Dynamic repository variables are refreshed by data returned from queries. The same rule applies here. If the query that refreshes the variable is using a
database function and evaluate then the whole query (report) will not be cached as the value of the variable cannot be cached.
If the query that refreshes the variable does not use database functions then it is cached and the report should be cached.
However, when the value of a dynamic repository variable changes, all cache entries associated with a business model that reference the value of the variable,
are purged automatically.

If you see the query in the Cache Manager then it means that is cached. You can check if that particular cached query is used or not by checking the “Last
used” column after the user ran the report. The cache should be used and the value of the “Last Used” column should be updated and different from the value
of the “Created” column.

Using iBots is an alternative. If you schedule the reports they should appear in the cache until the cache is purged. Keep in mind that reports having the
database functions and evaluate will not be cached either. Also, reports having dynamic repository variables will automatically be purged when the variable
The iBot should not include queries with database functions and evaluate in order to be cached.

Nominate your Organization for Oracle BI & EPM Excellence

It’s Tuesday, and there was a big tragedy in DC that everyone knows about. I ride on Red Line every day  – and now I’m starting to think that I’m not riding in front car anymore. However,  it’s quite possible that I’d have been riding the same train.

Official info about BI nomination is here – http://www.oracle.com/webapps/dialogue/dlgpage.jsp?p_ext=Y&p_dlg_id=7687732&src=6642150&Act=335

Probably the most interesting category for blog’s readers is this:

Using Oracle BI EE Plus to deliver intelligence and analytics from data spanning multiple sources and applications.

The criteria’s don’t seem too difficult – I suggest you at least forward the link to your manager – supervisor.The only thing that is not clear is whether the award is for 1 person, 10 people total, or 10 teams. Please let me know if you can figure it out.

Summer was slow for many business intelligence blogers – Adrian Ward posted something a humorous albeit interesting story –   “Don’t Try This At Home Kids” . John Minkjan came up with some cool scripts, such as Getting All Users and Roles from RPD

Other interesting findings – I found a post about all OBIEE and legacy products versions – http://blogs.oracle.com/bi/2009/06/ships_in_the_night.html by Darryn Hinett.

Something I just learned by an accident –  Venkatakrishnan J (one of the most respected Oracle BI experts and an author of authoritative OBIEE blog http://oraclebizint.wordpress.com/)  joined Rittman Mead consulting. Congratulations and Best wishes for all parties involved. You can read about it here – http://www.rittmanmead.com/2009/06/22/my-first-post-here-joining-rittman-mead/

Please stay safe

OBIEE Certification

Still there’s nothing from Oracle in regards to official OBIEE certification. Latest official info is here: http://blogs.oracle.com/certification/2008/09/obiee_certification.html

My personal opinion is that although a certification program would be nice, but not by any means necessary. I see several major problems with Oracle’s OBIEE certification:

a) possible requirement for compulsory training at Oracle University before taking certification – while taking training is not a bad idea in itself, financial issues arise. Who’s going to cover costs of this training? I’m sure that many people wouldn’t get reimbursed by  their employers at this economy.  Should they be paying by themselves? I’m sure that shelling out thousands of dollars out-of-pocket isn’t an attractive option for many people.  My last argument is that some people don’t really need (or feel that they need) to take training in order to pass the qualification exam.

b) Passing the majority of certifications is rarely requiring more than just answering multiple-choice questions. So in reality, it’s just about how well someone answers the questions, not the level of knowledge / proficiency with the technology. Of course, someone who’s adept at OBIEE would have no problems whatsoever answering the questions, but so is someone who just crammed the documentation well. There’s no way objectively distinguishing between them if they both passed the exam. I’m not even talking about brain dumps where one can get all the questions.

To be successful, the certification should involve some lab work. It should be accessible to anyone who could prove OBIEE proficiency (maybe with some preliminary test). And it shouldn’t be burdensome, Oracle shouldn’t use the certification as a revenue maker, but instead focus on building relationships and trust between consultants / developers and clients.