on 09-03-2008 3:21 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Do you have these variables in the filter of the planning sequence or you have just used the variables in the planning function?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.