QlikSense Sep 2017 - Teradata's Query Band

Anonymous — Thu, 03 May 2018 02:50:55 GMT

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";

Issue: OSuser() is not passed to teradata as expected;

Is anyone worked on this feature and guide me?

topic QlikSense Sep 2017 - Teradata's Query Band in Connectivity & Data Prep