Author |
Message |
Charles Killam Principal Member


Joined: 24 Apr 2003
               
*3 Posts: 310 Location: Colorful Colorado!!!!

|
Posted: Tue Feb 23, 2010 12:52 pm Post subject: Banding for Queries |
|
|
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:(  _________________ Charles A. Killam
Business Intelligence Consultant |
|
Back to top |
|
 |
Nick Daniels Forum Aficionado


Joined: 15 Aug 2002
                 Posts: 14239 Location: England

|
Posted: Tue Feb 23, 2010 1:12 pm Post subject: Re: Banding for Queries |
|
|
[Moderator note - moved to Semantic Layer forum] |
|
Back to top |
|
 |
Dave Rathbun Forum Advocate


Joined: 06 Jun 2002
                
*16 Posts: 22140 Location: Dallas, Texas

|
|
Back to top |
|
 |
Charles Killam Principal Member


Joined: 24 Apr 2003
               
*3 Posts: 310 Location: Colorful Colorado!!!!

|
Posted: Wed Mar 03, 2010 8:44 am Post subject: Re: Banding for Queries |
|
|
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:)  _________________ Charles A. Killam
Business Intelligence Consultant |
|
Back to top |
|
 |
Dave Rathbun Forum Advocate


Joined: 06 Jun 2002
                
*16 Posts: 22140 Location: Dallas, Texas

|
|
Back to top |
|
 |
Charles Killam Principal Member


Joined: 24 Apr 2003
               
*3 Posts: 310 Location: Colorful Colorado!!!!

|
Posted: Wed Mar 03, 2010 11:38 am Post subject: Re: Banding for Queries |
|
|
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........
 _________________ Charles A. Killam
Business Intelligence Consultant |
|
Back to top |
|
 |
Dave Rathbun Forum Advocate


Joined: 06 Jun 2002
                
*16 Posts: 22140 Location: Dallas, Texas

|
|
Back to top |
|
 |
|