BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

Banding for Queries


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
Charles Killam
Principal Member
Principal Member



Joined: 24 Apr 2003

speaker.gif*3
Posts: 310
Location: Colorful Colorado!!!!


flag
PostPosted: 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:( crazy.gif

_________________
Charles A. Killam
Business Intelligence Consultant
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 14214
Location: England


flag
PostPosted: 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
Forum Advocate



Joined: 06 Jun 2002

speaker.gif*16
Posts: 22124
Location: Dallas, Texas


flag
PostPosted: Tue Feb 23, 2010 1:39 pm 
Post subject: Re: Banding for Queries

Certainly looks interesting, I have passed it to our DBA team. I suspect it could go into the ConnectInit area of the connection definition.
_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2019-02-11 Update on Query Banding
• 2018-10-19 BI Evolution
• 2018-09-13 Copying Content Is Not A Complement
Back to top
Charles Killam
Principal Member
Principal Member



Joined: 24 Apr 2003

speaker.gif*3
Posts: 310
Location: Colorful Colorado!!!!


flag
PostPosted: 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:) thumbsup.gif seeya.gif lol.gif

_________________
Charles A. Killam
Business Intelligence Consultant
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

speaker.gif*16
Posts: 22124
Location: Dallas, Texas


flag
PostPosted: Wed Mar 03, 2010 11:29 am 
Post subject: Re: Banding for Queries

For those on earlier versions (BEGIN_SQL was not available in XI R2) the ConnectInit is also working just fine.
_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2019-02-11 Update on Query Banding
• 2018-10-19 BI Evolution
• 2018-09-13 Copying Content Is Not A Complement
Back to top
Charles Killam
Principal Member
Principal Member



Joined: 24 Apr 2003

speaker.gif*3
Posts: 310
Location: Colorful Colorado!!!!


flag
PostPosted: 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........

crazy.gif

_________________
Charles A. Killam
Business Intelligence Consultant
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

speaker.gif*16
Posts: 22124
Location: Dallas, Texas


flag
PostPosted: Wed Mar 03, 2010 11:42 am 
Post subject: Re: Banding for Queries

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.
_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2019-02-11 Update on Query Banding
• 2018-10-19 BI Evolution
• 2018-09-13 Copying Content Is Not A Complement
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0287 seconds using 17 queries. (SQL 0.0028 Parse 0.0009 Other 0.0249)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo