Hi,
Is anyone used Teradata's Query Band in Qlik Sense.
* Qlik Sense. September enterprise 2017 version
* Teradata 16 database
* Teradata System DSN created after its ODBC driver installation (test connection success)
* I would like use teradata's query band to pass the OSuser() to teradata
below is the script
LIB CONNECT TO <Teradata Connection>;
SET SQLSessionPrefix = 'SET QUERY_BAND = ' & Chr(39) & 'Who=' & OSuser() & ';' & Chr(39) & ' FOR SESSION;';
DIRECT QUERY
DIMENSION "D1"
MEASURE "M1"
FROM "DB"."Table";
https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/DirectDiscovery/direct-d...
Issue: OSuser() is not passed to teradata as expected;
Is anyone worked on this feature and guide me?