Banding for Queries

[Charles Killam]

Has anyone heard of or had any experience with Teradata banding feature (like a bird - adding metadata to each report for another level of tracking/auditing)

http://www.teradata.com/tdmo/Tech2TechTemplate.aspx?id=10797

Looks like we may be trying to use it and I had never heard of it:(

[Nick Daniels]

[Moderator note - moved to Semantic Layer forum]

[Dave Rathbun]

Certainly looks interesting, I have passed it to our DBA team. I suspect it could go into the ConnectInit area of the connection definition.

[Charles Killam]

For anyone interested, the Teradata Query Banding can be activated by using the BEGIN_SQL paramater in a universe and BO standard variable and fixed text can be submitted using a syntax like this

SET QUERY_BAND='UserID='@Variable('BOUSER')'; Document='@Variable('DOCNAME')';Application=BusinessObjects;' for transaction;

I am trying to add some window system variables as well but have not determined the correct syntax for that yet. Will update if and when I get that piece.

Thanks for those of you that had comments, thoughts and ideas on this:)

[Dave Rathbun]

For those on earlier versions (BEGIN_SQL was not available in XI R2) the ConnectInit is also working just fine.

[Charles Killam]

How does Query Banding get implemented using ConnectInit - I am not familiar with how to modify that or where it is done (and could not find any documentation to reflect it).

Thanks........

[Dave Rathbun]

You basically put the entire statement in the ConnectInit parameter. I have just about finished a blog post with screen shots, hopefully will be done in a few days.