WAD : problem data binding with EXEC_PLANNING_FUNCTION

[Former Member]

Hi Gurus,

I have a Web Template with one input-query restricted on a single year. Users can copy the data to another year by a copy buton.

I call the function with EXEC_PLANNING_FUNCTION and restrict some axes by data binding with the value of the input-query.

The function is a IP copy function with two variable u201CSource Yearu201D and u2018Target Yearu201D.

My problem is that the values passed by data binding donu2019t affect the filter of the function when the popup is open to input the values for variable u201CSource Yearu201D and u2018Target Yearu201D.

If I replace in the function the variables by values (example 2009 and 2010) or if I use INPUT_FIELD to input the values of the variables (so no popup open), all is OK.

For information, the SP of system is 14.

Thanks for your help,

Franck

[Former Member]

Hi Franiatte,

Did you able to solve this pop issue? I have similar issue and if you solved the issue please give us detail steps.

Thanks

Pugal

[Former Member]

Yes, I can use a planning sequence but all the variables of the filter are displayed in the popup (example country, material, ...) and i only want to display the "Source Year" and "Target Year".

With the function, i can pass the value for country and material by binding and thus not use variables who are shown in the popup.

So i can use a planning sequence or use a query like a filter with EXEC_PLANNING_FUNCTION_SIMPLE instead of EXEC_PLANNING_FUNCTION but it's not really my question.

I think it' a bug who are clear the values pass by data biding before/after the popup when a variable is needed.

[Former Member]

Hi Franck,

When you call a planning sequence using a button and change the variable dialog, you can solve this problem setting the variable at EXEC_PLANNING_SEQUENCE_* config.

Force the variable name at connection data and it will work.

Cheers.

KMT

[Former Member]

Hi Franiatte,

in general the recommed way is using planning sequences. For the variable binding the usual case is to bind a variable to a variable.

So I asssume that in your query you have a variable for the year.

Please create a planning sequence which includes your copy function and a filter which contains your variables source and target.

In WAD call your planning sequence and bind the variables year to source year and e.g. year to target year and show the variable dialog.

Hope this helps ...

Matthias