Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a user that added some SQL code to a qvd load that caused the below error.
He ran the code on SQL server fine, but apparently Qlikview does not like the same code when trying to load a Qvd. The code is running as below, is tehre a specific change that Qlikview needs to recognize these defined functions?
SQL SELECT
SEQUENCE_NUM,
DEBT_INFO_1,
DEBT_INFO_2,
DIRECT_MAIL_SCORE,
TSYS_RATE,
DBO.UDF_SCORE_RANK(SEQUENCE_NUM) AS SCORE_RANK,
DBO.UDF_GROSS_RESPRATE(SEQUENCE_NUM) AS GROSS_RESPRATE,
DBO.UDF_NET_RESPRATE(SEQUENCE_NUM) AS NET_RESPRATE,
DBO.UDF_QUALIFY_RATE(SEQUENCE_NUM) AS QUALIFY_RATE
FROM BTOffer.dbo.VW_SOURCE_RECORD_ALL
Please check the QV user account access to user defined function in the schema ?