Cognos提示functprompt函数

我正在使用以下命令参数:

[BUSINESS VIEW].[All Business View].[STAGES] in (prompt('STAGES1','string','Arrival announced'))

[BUSINESS VIEW].[All Business View].[NEXTSTAGE] in (prompt('NEXTSTAGE','string','Arrival announced'))

如您所见,我正在尝试设置默认值,以防用户没有选择其中一个都是可选的 .

运行报表时出现此错误:

"XQE-DAT-0001

Data source adapter error: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=PROMPT;FUNCTION, DRIVER=3.63.123 - when processing query: SELECT

“COGNOS” . “TERMINALNAME”作为“TERMINALNAME”,“COGNOS” . “CCN”AS“CCN”,“COGNOS” . “CIDENTIFICATION”AS“CIDENTIFICATION”,“COGNOS” . “STAGES”AS“STAGES”,“COGNOS” “ . ”NEXTSTAGE“AS”NEXTSTAGE“,SUM(”COGNOS“ . ”TIMETAKEN“)AS”TIMETAKEN“来自”KAP“ . ”COGNOS“”COGNOS“中”COGNOS“ . ”STAGES“IN(提示('STAGES1') ,'string','Arrival宣布'))和“COGNOS” . “NEXTSTAGE”IN(提示('NEXTSTAGE','string','Arrival announce'))GROUP BY“COGNOS” . “TERMINALNAME”,“COGNOS” . “CCN”,“COGNOS” . “CIDENTIFICATION”,“COGNOS” . “STAGES”,“COGNOS” . “NEXTSTAGE” . “

我一直在努力设置默认值为参数,以防用户没有选择,但没有找到让它成功运行的方法 . 有谁幸运吗?

回答(1)

3 years ago

[BUSINESS VIEW].[All Business View].[STAGES] in (#promptmany('STAGES1','string','''Arrival announced''')#)

[BUSINESS VIEW].[All Business View].[NEXTSTAGE] in (#promptmany('NEXTSTAGE','string','''Arrival announced''')#)