Skip to Content
0
Former Member
Sep 12, 2007 at 08:16 PM

Pass variable from Template to Query

22 Views

Hi !

I'm trying to pass a variable value from a template to a query, and it works fine as long as i want to pass the same value to all queries.

i use :

<object>

<param name="OWNER" value="SAP_BW"/>

<param name="CMD" value="SET_PROPERTIES"/>

<param name="TEMPLATE_ID" value="ZBI02T14"/>

<param name="VAR_NAME_3" value="ZBI2V174"/>

<param name="VAR_VALUE_EXT_3" value="2"/>

TEMPLATE PROPERTIES

</object>

And all the queries take the value 2 for the variable ZBI2V174.

But on the next Template, i need to use several times the same query but with different values on that Variable, for example, use Query Q35 with variable ZBI2V174 = 1, then same query with ZBI2V174 = 2, etc

I have tried sending the variable on each query, but it hasn't work:

<object>

<param name="OWNER" value="SAP_BW"/>

<param name="CMD" value="SET_DATA_PROVIDER"/>

<param name="NAME" value="REPORTEBANDASPASIVO"/>

<param name="QUERY" value="ZBI02Q35"/>

<param name="INFOCUBE" value="ZBI02C01"/>

<param name="VAR_NAME_3" value="ZBI2V174"/>

<param name="VAR_VALUE_EXT_3" value="2"/>

DATA_PROVIDER: REPORTEBANDASPASIVO

</object>

How can i do that? Having the same query 4 times on 1 Template, but passing a diferente value true the same variable to each query

Thanks,

Jorge Saenz