Skip to Content
0
Former Member
Jun 07, 2011 at 09:15 PM

Query Banding with Teradata

371 Views

I have BO XI 3.1 SP3 and using Teradata 13 as reporting database. I am trying to enable Query Banding, so added BEGIN_SQL command in the Universe connection parameter.

It worked for Webi report, when ever I run a Webi report it showed up in the TTU query log but when I run a Deski report then it is not showing any log. Is there anything specific needs to be done for Deski reports.

And also if I want to do Query Banding for Crystal then what I have to do.

Below is the command I added in the connection parameter.

BEGIN_SQL: SET QUERY_BAND='UserID='@Variable('BOUSER')';Document='@Variable('DOCNAME')';Universe='@Variable('UNVNAME')';' for transaction;