How to use the EVALUATE function in OBIEE?

862823

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

Joel

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

cesar.advincula.o

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;

————-

862823

Hi Joel,

I searched but could not hit the syntax :-(

Luciana

Joel

Cesar has just given you a code snippet which should sort you out.

Sent from my iPhone

862823

Hi Cesar,

Thank you. I'll check and test

Luciana

862823

Hi Cesar,

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.

Luciana

Joel

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.

862823

Hi Joel,

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.

Luciana

Joel

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.

cesar.advincula.o

Sorry by delay.. Yes, should 2. ( the evaluate parameter ) and the syntax should works.. Apply what joel said