Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When I reload my QlikView file an error has occurred with a dialog box named ''Script Error'': " SQL Evaluate('Outstanding')".
But my connection string is correct and there is error in my script. I connect the Qlikview file with SSAS Tabular Model through Analysis Service 10. When I change my connection string after getting error, i reload my script then this tab run successfully but one of the other tab got error and show the same dialog box.
Is anyone know what is the problem? I need the solution badly!!
Thanks in advance
Is the Evaluate() function in the LOAD part of the script (therefore, handled by QlikView) or instead on the SQL SELECT part of the script (therefore handled by the DBMS)?
If the former, start by commenting the line altogether and run the load. If the latter, check the right syntax for SSAS.
Believe Miguel was on the right track here, things appear to be an issue on the SQL side of things, not Qlik, as that SQL Evaluate('Outstanding') is being passed as part of the OLE DB connect, there has to be something the connection does not like about things. I would venture the Microsoft forums are likely going to be the better option to get further information on this one. Generally though, I would recommend putting the Connect To statement before you start the Load statement at all, that way the connection is in place prior to the load statement trying to do anything, that might fix things here now that I think about it, but I am not certain.
Found the following article that may be helpful as well:
Regards,
Brett
Thanks BrettBleess. I am working on it.
This is the error.
Really need the full script/document log at this point to try to help further:
How to generate script/document log...
Regards,
Brett