Latest News

Saturday, April 26, 2014

Calling Database function in OBIEE 11g

Calling Database function in OBIEE 11g

Sometimes we need to call a database function to OBIEE to achieve different Business need.

In OBIEE 11g it is quite simple to call a Database Function using EVALUATE function.

Create a function in Oracle DataBase and use EVALUATE function as below syntax:

EVALUATE(‘dbfunction_name(%1,%2)’, parameter list)

In the above Syntax %1& %2 are number of parameters to be passed to the DataBase function. Parameters can be more than or less than 2 depending on the requirement. These can also be constant/hard coded values

Note : By default in OBIEE, support for the EVALUATE family of database functions is disabled. EVALUATE_SUPPORT_LEVEL parameter in NQSConfig.INI should be changed to enable support for the EVALUATE functions. See Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition for more information.

If EVALUATE_SUPPORT_LEVEL parameter not enabled below error can appear while using the Evaluate function on Analysis.

  • Google+
  • Pinterest


  1. Oracle Database Training will help you develop a thorough understanding of Oracle Database, as well as its related products. With more than 50 Database offerings, enhance your knowledge of Database 11g, MySQL, Data Guard, and more.

    SQL Training
    Oracle Training Institutes in Chennai

    1. IEEE Final Year Project centers make amazing deep learning final year projects ideas for final year students Final Year Projects for CSE to training and develop their deep learning experience and talents.

      IEEE Final Year projects Project Centers in India are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation.

      corporate training in chennai corporate training in chennai

      corporate training companies in india corporate training companies in india

      corporate training companies in chennai corporate training companies in chennai

      I have read your blog its very attractive and impressive. I like it your blog. Digital Marketing Company in Chennai

  2. I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.
    Oracle DBA Training in Chennai|Oracle Training Chennai

  3. The strategy you have posted on the oracle hepled me to get into the next level of this technology and had lot of informations in it.
    oracle training in chennai | oracle training institutes in chennai

  4. Your style is very unique compared to other folks I've read stuff from. Many thanks for posting when you have the opportunity, blog Guess I will just book mark this site.
    IELTS Coaching in chennai

    German Classes in Chennai

    GRE Coaching Classes in Chennai

    TOEFL Coaching in Chennai

    spoken english classes in chennai | Communication training

  5. I really appreciate this wonderful post that you have provided for us. I assure this would be beneficial for most of the people. Business Coaching

  6. Cool stuff you have got and you keep update all of us. online calling card

  7. Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article. thank you for sharing such a great blog with us.

    Oracle Training in Bangalore

  8. This is a fabulous article, please try to give more useful information.
    fibonacci series in python using for loop
    inheritance in python

  9. valuable blog,Informative content...thanks for sharing, Waiting for the next update...
    Cyber Security Course in Chennai
    Cyber Security Training in Chennai

  10. Post is really impressive... Thanks for the data update and waiting for your new updates.
    Android Training in Chennai
    Android Online Training
    Android Training in Coimbatore


  11. I am impressed by the information that you have on this blog!
    "cyber security course in hyderabad