Hi Gianni, Thank you. The problem was solved by the link you suggested ;-) https://wapcobiee.wordpress.com/2015/12/18/obiee-foprocessor-cannot-run-without-a-valid-tmp-directory/ Luciana

Thank you Cesar and Joel. It worked :-)

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

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…

Hi Cesar, Thank you. I'll check and test Luciana

Hi Joel, I searched but could not hit the syntax :-( Luciana

Excelente Cesar, It worked :-) Thank you so much for your attention Luciana

Hello Cesar, Thank you for your attention :-) I realized that the period of all examples found on the web, are from year to year. The XIRR function shows different values when periods change from year to year to month to month. The TIR function does not change the values when these periods are changed. I need the XIRR…

Hi Cesar, I tried to execute the steps of the PL/SQL to calculate XIRR in Oracle link and the function returned the same data found by Satyaki_De (v_Return = .248719024658203125) I simulated the calculation of the IRR in excel for the same values reported and the result was different This function is correct? Att, Luciana

Good idea Cesar. I will check this information ;-) Thank you Luciana

Hum. Thank you for this information Cesar

Thank you for the sugestion :-) I had found this link but could not understand how I would use it in the report. The IRR needs to be calculated at run time because it will depend on three user information: time period, rate, and value :-( Luciana