Symptom
In IDT UNX with Teradata using SET query_band='proxyuser=@Variable(''BOUSER'');' for transaction;..should replace the connection credentials with the BOUSER logged in.
The credentials are not replaced and an error message occurs. Invalid SET statement in the triggered action.ERROR COMPONENT="WIS" ERRORCODE="10901" ERRORTYPE="USER" MESSAGE="Database error: [Teradata][ODBC Teradata Driver][Teradata Database] The user does not have SELECT access to table
Read more...
Environment
- SAP BusinessObjects Business Intelligence platform
- Information Design Tool (IDT)
- Teradata
Product
Keywords
ADAPT01674197 ADAPT 01674197 teradata tera data @variable variable bouser query band queryband query_band , KBA , BI-BIP-IDT , Information design tool , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.