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
« PREV
NEXT »

13 comments

  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

    ReplyDelete
    Replies
    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

      Delete
  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.
    Regards,
    Oracle DBA Training in Chennai|Oracle Training Chennai

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

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

    ReplyDelete