After connecting to Teradata Database, Teradata OLAP Connector automatically sets the query band for the session, such as an Excel session, as shown in the example below. The parameter {0}, including the braces, is replaced with the Teradata Database user ID of the client user. The parameter {1}, including the braces, is replaced by the current Teradata OLAP Connector version, for example 14.10.00.00. The parameter {2}, including the braces, is replaced with the name of the published schema associated with the client session. The parameter {3}, including the braces, is replaced with the name of the cube associated with the client session.
The DBA can configure query band priority for a name/value pair to enable query band prioritization. For example, the priority can be set based on the application name/value pair, such as Application=Teradata OLAP Connector. You can also set the priority based on a userid name/value pair.
Example - Job Prioritization
SET QUERY_BAND='UserId={0};ApplicationName=Teradata OLAP Connector;Version={1};Schema={2};Cube={3};' FOR SESSION