Writen by
Devil
7:03 PM
-
13
Comments
Calling Database function in OBIEE 11g
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.
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.
ReplyDeleteSQL Training
Oracle Training Institutes in Chennai
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.
ReplyDeleteoracle training in chennai | oracle training institutes in chennai
Great post. keep sharing such a worthy information
ReplyDeleteGerman Classes in Chennai
German Classes in Bangalore
German Classes in Coimbatore
German Classes in Madurai
German Language Course in Hyderabad
German Language Classes in Chennai
German language classes in bangalore
German Language Classes in Coimbatore
Ethical Hacking Course in Bangalore
IELTS Coaching in Bangalore
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
ReplyDeleteCool stuff you have got and you keep update all of us. online calling card
ReplyDeleteExcellent post...! It is a very great idea and unique content. Thank you so much...
ReplyDeleteOracle Training in Chennai
Oracle Training in Coimbatore
Oracle Training in Bangalore
Oracle DBA Training in Chennai
Oracle DBA Training Institute in Chennai
Power BI Training in Chennai
Appium Training in Chennai
This is a fabulous article, please try to give more useful information.
ReplyDeletefibonacci series in python using for loop
inheritance in python
Aivivu chuyên vé máy bay, tham khảo
ReplyDeletemở lại đường bay việt nam - hàn quốc
giá vé máy bay vinh sài gòn
giá vé máy bay đà nẵng hà nội
vé máy bay hà nội nha trang tháng 7
vé máy bay đi Mỹ bao nhiêu tiền
taxi sân bay nội bài
ReplyDeleteAmazing post.Thanks for sharing.........
Cyber Security Course in Pune
Cyber Security Course in Gurgaon
Cyber Security Course in Hyderabad
Cyber Security Course in Bangalore
ReplyDeleteI am impressed by the information that you have on this blog!
"cyber security course in hyderabad
Very interesting blog. A lot of blogs I see these days don't really provide anything that I'm interested in, but I'm most definitely interested in this one. Just thought that I would post and let you know.
ReplyDeleteTourism packages
Very interesting blog. A lot of blogs I see these days don't really provide anything that I'm interested in, but I'm most definitely interested in this one. Just thought that I would post and let you know.
ReplyDeleteTourism companies in Pakistan
ReplyDeleteNice informative content. Thanks for sharing the valuable information.
RPA Training in Chennai
RPA Training Online
RPA Training In Bangalore