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