SAP Knowledge Base Article - Preview

1794733 - @VARIABLE('BOUSER') Teradata In IDT

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

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1

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.