Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to use the EVALUATE function in OBIEE?

Received Response
2366
Views
11
Comments
Rank 3 - Community Apprentice

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

Welcome!

It looks like you're new here. Sign in or register to get started.
«1

Answers

  • Rank 8 - Analytics Strategist

    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

  • Rank 6 - Analytics Lead

    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;

    ————-

  • Rank 3 - Community Apprentice

    Hi Joel,

    I searched but could not hit the syntax :-(

    Luciana

  • Rank 8 - Analytics Strategist

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

    Sent from my iPhone

  • Rank 3 - Community Apprentice

    Hi Cesar,

    Thank you. I'll check and test

    Luciana

  • Rank 3 - Community Apprentice

    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

  • Rank 8 - Analytics Strategist

    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.

  • Rank 3 - Community Apprentice

    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

  • Rank 8 - Analytics Strategist

    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.

  • Rank 6 - Analytics Lead

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

    Screen Shot 2017-01-11 at 1.45.21 PM.png

    Screen Shot 2017-01-11 at 1.40.42 PM.png

    Screen Shot 2017-01-11 at 1.45.28 PM.png

    Screen Shot 2017-01-11 at 1.50.57 PM.png

Welcome!

It looks like you're new here. Sign in or register to get started.