Hi,
I have a function in the oracle database called FNC_TEST( PDATE in date, PQTDE number).
How to use the EVALUATE function for this function?
Luciana
Do a quick Google search - http://obieetutorialguide.blogspot.ch/2012/03/database-evaluate-function.html?m=1
There are loads of blog articles and you could also search Oracle's extensive documentation as well.
Sent from my iPhone
Hello
Luciana,
Do something like this
EVALUATE('FNC_TEST(%1,%2)' AS NUMBER, columnofyourobiee1, columnofyourobiee2)
*NUMBER: depends on the type of value that you get NUMBER, CHAR, etc.
Its not clear in your function what kind of value do you get if it is a NUMBER CHAR FNC_TEST( PDATE in date, PQTDE number).
Also you have to go the NQSConfig.INI and set up the EVALUATE_SUPPORT_LEVEL
EVALUATE_SUPPORT_LEVEL:
# 1: evaluate is supported for users with manageRepositories permssion
# 2: evaluate is supported for any user.
# other: evaluate is not supported if the value is anything else.
EVALUATE_SUPPORT_LEVEL = 0;
————-
Hi Joel,
I searched but could not hit the syntax :-(
Cesar has just given you a code snippet which should sort you out.
Hi Cesar,
Thank you. I'll check and test
I changed the EVALUATE_SUPPORT_LEVEL value for 0 in the NQSConfig.INI and after that i restarted the OBIEE services.
My function will return a number.
In this case, the corret sintaxe is: EVALUATE('FNC_TEST(%1,%2)' AS NUMBER, columnofyourobiee1, columnofyourobiee2) ?
I applieded this syntax in my function but happened this error: The syntax of the formula is invalid.
You'll need to replace columnofyourobiee1 and columnofyourobiee2 with your actual OBIEE Presentation Column names, for example, "Time"."Calendar date".
Also, you'll need to change EVALUATE_SUPPORT_LEVEL to 2 to enable all users to use the EVALUATE function.
I used
EVALUATE('FNC_TEST(%1,%2)' AS NUMBER, "- Dimensão Data Implantação"."Data Implantação", "- Fato AFP Head"."Qtd Prestações")
but the EVALUATE_SUPPORT_LEVEL was 2 and i changed it for 0.
Hi Luciana
I forgot to mention that you will also need to restart your BI Server after making the NQSConfig.ini change. EVALUATE_SUPPORT_LEVEL needs to be set to 2 and I can't see anything wrong with your EVALUATE syntax.
Sorry by delay.. Yes, should 2. ( the evaluate parameter ) and the syntax should works.. Apply what joel said
