I forgot saying that is in OBIEE 11g. Tnks

yes, but i don't find where. Could you say me where can i change it please?

Thanks for your answer, but what you said is for "obiee answers" and i'm working with BI Publiser (layout builder not RTF)

Hello Joel, The evaluete function works, the error just happens when i do drill down.

Thanks a lot Gionni. It works perfect !!!

Gianni, The version is OBI 12c. I send the screenshot. Don't understand ' better set the mapping to logical columns in the LTS instead of the column', can you explain me please?

Thanks for your answer orcllover, i tried that but appears an error because the 'filter using' just work if the filter is by a dimension and i need filter the fact where a meassure is > 0.

Tnks Robert, I did it... but the calculated column data type does not change at the business model. Obiee always set double.... and double is not data type for sql server. I don't understand the error.

Ahh ok tnks. Please... I can't see the bug. Is it the correct number? MOS say it does not exist.

I did not find that OPR4ONWY:OI2DL65P means that. Then i can conclude that 'evaluate' need returns a boolean??

Christian, Where did you find the text error?? It has sense. My function returns an integer as 1 or 0. Does 'evaluate' need that i return a boolean??

ok thanks, but then why it shows that error?? I chage to 7 the log level and the logs show the same, no detail about the error.

Christian, the function database is correct over sql server, it doesn't have errors. What you want to say is I can´t call with "Evaluate" a microsoft sql server function database?? Evaluate Just works whit oracle databases?? I have the RPD connect to sql server database and all my analysis and dashboards works ok. The log…

Ok Gianni.... inicially i'm testing from Administration-> Issue SQL. If it works what i need doing is execute a procedure or function database (sql server) from a dashboard and send it some user parameters, the procedure must making a process according that parameters and insert data to a table , then i must show the…

Christian thanks for your answer. I saw the obis1-query.log and appears this: b37bbde5 EVALUATE('dbo.fnc_prueba_evaluate(%1,%2)' AS int, 'A' , 'X') /* QUERY_SRC_CD='rawSQL' */ In obis1-diagnostics.log no shows anything, what it means there is no a sintax error. Does exist another log where i can see? Tnaks for your help.

Obiee 12c version 12.2.1.2.0 , sqlserver database is the datawarehouse. A custom RPD. Tnks for your help!!!