cancel
Showing results for 
Search instead for 
Did you mean: 

Query Banding

Former Member
0 Kudos

Hi All,

I have to Implement query banding In BOBJ 4.0, 

I Pasted

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

This code works fine with 3.1 when i see the sql script(see the snapshot), But fails in 4.0. I do not see it in sql as in snapshot, Kindly Help me.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member193452
Active Participant
0 Kudos

http://wiki.scn.sap.com/wiki/x/lAJcFg

Hi Raveesh,

Please take a look at my Wiki  on Query Banding.

There were changes to syntax in 4.0 vs. 3.1.  If this is Teradata specifically.

Thanks,

Jacqueline

former_member4998
Active Contributor
0 Kudos

Hi

I think the problem with @Variable('BOUSER')..try with below syntax.

QUERY_BAND='Universe='@Variable('UNVNAME');Document='@Variable('DOCNAME'); BOUSER = '@Variable('BOUSER')';'For Transaction;

http://www.dagira.com/2010/06/08/using-connectinit-for-teradata-query-banding/

http://downloads.tableausoftware.com/quickstart/feature-guides/queryband_teradata.pdf