Skip to Content
avatar image
Former Member

workbooks pass values to sequence

Hello gurus,

When i try to pass values from workbook to planning sequences, system doesn't lock the values i'va passed on a selection options variable.

I've tryied to pass values like:

VAR_NAME_1 1 ZIOMIND_SOM

VAR_VALUE_EXT_1 1 ST

VAR_SIGN_1 1 I

VAR_OPERATOR_1 1 EQ

VAR_NAME_2 1 ZIOMIND_SOM

VAR_VALUE_EXT_2 1 OF

VAR_SIGN_2 1 I

VAR_OPERATOR_2 1 EQ

but the problem is that it gives me a lock problem, and when i go see lock conflict the lock doesn't have values for this variables.

Could you help me on this?

Thanks in advance,

Vitor Ramalho

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 03, 2008 at 04:12 PM

    Do you have these variables in the filter of the planning sequence or you have just used the variables in the planning function?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 05, 2008 at 05:24 AM

    Hi Vitor,

    As you have mentioned your query have a select options exit variable (Z_REST2_CC) on the filter.

    Make sure sequences filter, Should also have a select options variable (Z_REST2_CC) .As sequence will always gets executed with respect to modeler filter.I think this can be one reason why values are not locked by any values for costcenter that you have passed.

    Secondly you can also pass costcenter values through command range in workbook.

    Rgds,

    Indu

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      HI Vitor,

      Normally when you want to change the values of variables during query navigation you have to assign the variables also to the 'Defualt values' in the query (it is in the right side next to the filter area),but i am not sure that it is possible when characteristic has a compunding like controling area to the cost center ,please move tha variable to defualt values and try it.

      Regards,

      Eitan.