on 05-09-2014 4:36 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.