oracle 了解 OBIEE 中的评估函数
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/22629381/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Understanding evaluate function in OBIEE
提问by sar04x
I read some stuff on OBIEE Evaluate function and could not really understand as I am new to this.
我读了一些关于 OBIEE Evaluate 函数的东西，但我不太理解，因为我是新手。
EVALUATE('GetValue(%1,''SELECT MAX(P3_LST37) INTO :strValue FROM MV_ITEMSX WHERE ITEM_NUMBER = XXXX '' )' AS VARCHAR(2000), "Product")
Can you please help me to understand the function describe above?
你能帮我理解上面描述的功能吗？
Thanks
谢谢
回答by user1320453
The Evaluate function enables you to send a function to the database to evaluate and return data to OBIEE. For security purposes you must use references in the function rather than the values themselves.
Evaluate 函数使您能够将函数发送到数据库以评估数据并将数据返回给 OBIEE。出于安全目的，您必须在函数中使用引用而不是值本身。
For example, if I have a column "Core"."Date" which returns the date as a string and want to use the TO_DATE function of evaluate, I would issue the following evaluate expression:
例如，如果我有一列 "Core"."Date" 以字符串形式返回日期并希望使用评估的 TO_DATE 函数，我将发出以下评估表达式：
EVALUATE('TO_DATE(%1,'DD-MON-YYYY') AS DATE',"Core"."Date")
EVALUATE('TO_DATE(%1,'DD-MON-YYYY') AS DATE',"Core"."Date")
Hope that helps.
希望有帮助。
