Command for planning sequence in analyzer

[Former Member]

Hi,

I have some exit variables inside the query columns (dynamic filter). I am reading these variable values in FOX code and this function is in one sequence. Now when i attach the planning sequence in button, and run it, it is not able to read these variable values. How can i do that? I just gave the command as execute planning sequence, sequence name and data provider filter.

Please let me know.

[Former Member]

Hi,

Variables used in planning functions don't get merged with the variables of same name in the query.

So, in your case though you are using the variable in your query as dynamic filter but the system will not read these variable values as values for the variable used in your planning function.

What you can do is specify the same variable in the filter that you have used in planning sequence for your planning function and then test.

Please let me know if this resolves your problem.

Regards,

Deepti

[Former Member]

Hi,

I cannot add these variables in the filter of plng function because for one characterstic, i am reading two variables in the code, i cannot restrict a char by 2 variables in the filter if i am not wrong. The main problem is here, query and planning sequence are using the same filter, but the variable values selected for running the query are not getting transferred to the planning sequence. Is there any way to resolve this issue?

Thanks,

Bindu

[Former Member]

Hi,

Create a new variable of replacement path type 'Manual Input' and use that in your planning function in place of exit variable.

Store the value of exit variable that is getting determined in query in some cell in your workbook, hide that cell and pass that value as variable value using command range option of the button to your planning function for the new variable.

Regards,

Deepti

[Former Member]

Can you please let me know if the same filter is getting used by planning sequence and query, will the selected variable values in the query be present for sequence also, or do we need to seperately select the variable values?

In my case, i have one fox code which reads a variable for currency, which is dependent on country selected by user. Currency variable is not in static filter, used in the column of the query. Query runs perfectly fine. When i click on the button of plng sequence,as fox reads currency variable value, it is going into the code for currency, but coluldnt read country variable value, so currency is becoming blank. So function is not running as required.

[Former Member]

Hi,

System will not consider the values that are selected in query for execution of planning sequence even if the filter is same.

What you can do is pass the value of country selected in the query via command range to your planning function using a normal Manual Input variable say ZCNTRY .

Then in your FOX you can read the value of ZCNTRY and based on this can determine the value of currency.You can rather use a custom function module to determine the value for currency based on country than to use exit variable and call this function module using CALL FUNCTION in FOX.

Regards,

Deepti

[Former Member]

In fox code, i have given like below. Now it could read currency value

country = VARV(country variable)

currency = VARV(currency exit variable) "currency exit variable reads the above country variable

Issue is solved.

[Former Member]

Hi,

Did you use exit variable for Country?

Regards,

Deepti

[Former Member]

No, country is authorization variable. I observed that, if we want to read any exit variable which itself is reading some other variables inside fox code, we have to read these variables also inside fox, otherwise it will not run properly.

For ex:

country is authorized

currency is exit which is based on the above country variable

Now to get currency value in fox code, we have to code like this

country = VARV(country variable)

currency = VARV(currency variable)

[manish_jain7]

Hi Bindu,

Your commands are correct. Also add Variable names in the command wizard and value for it is = filter name.

Planning sequences (by default) uses the variables defined in the planning query.

Regards,

MJ