workbooks pass values to sequence

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Indu,

Thanks for your reply.

But variables are both of type selectiopn options.

Any other ideas?

Best regards,

Vitor Ramalho

[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.

[Former Member]

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

[Former Member]

I have this variables on the filter of planning sequence.

Could you please help me on this...

Regards,

Vitor Ramalho

[Former Member]

Can you give more details - about your filter, the variables used in it, the values that you are passing and what locks do you see in RSPLSE?

[Former Member]

on my query i have a select options exit variable (Z_REST2_CC) on the filter.

on sequences filter, i have a select options variable (Z_REST_CC).

on my workbook i pass values to variable Z_REST_CC like this:

VAR_NAME_1 1 Z_REST_CC

VAR_VALUE_LOW_1 1 Z_REST2_CC-LOW

VAR_VALUE_HIGH_1 1 Z_REST2_CC-HIGH

VAR_SIGN_1 1 I

VAR_OPERATOR_1 1 EQ

when i execute sequence, i go to lock entries, and values are not locked by any values for costcenter (values that i pass on variables are costcenter values).

Could you help me on this?

Thanks in advance,

Vitor Ramalho

[Former Member]

Hi Vitor,

could you check note 1121654.

Regards Matthias Nutt

[Former Member]

Hi Mathias,

I'm on SP 18, so this note is not applicable. Any other ideas?

Thanks in advance,

Vitor Ramalho

[Former Member]

Not getting any ideas really. One basic thing - do you get lock for costcenter when you run the input query? Was just wondering if costcentre is there in the lock relevant characteristics.

[Former Member]

Yes, when i run input query, costcenter is locked. But then, i wnat to pass that costcenter to planing sequence and nothing...

Thanks,

Vitor Ramalho