Hi,
I have an input ready query based on an aggregate with a filter which I can enter contract planning data in to. The user enters one contract (specified as a manual input variable) at a time, so they would need to change variable values whenever they wanted to change the contract which they are planning on.
In the filter (in the Integrated Planning modeler), I have set the option in the advanced view to say that Contract can be changed at execution time and then indicated the same variable.
When trying to change the contract at execution time (ie. after the query has run once), I receive a warning with the following message :
<i>The 'Can be changed in query navigation' property has been set for variable ZV000009, characteristic ZCONTPL. However, the variable is used in the query in such a way, that the system is unable to apply this change-option.
This can, for example, occur under the following conditions:
Characteristic ZCONTPLis filtered by additional restrictions (the restrictions must be joined using an OR-connection)
A second characteristic, which is restricted by a variable, is compounded to charcteristic ZCONTPL.
Variable ZV000009 is a hierarchy node variable, but the hierarchy has not been determined uniquely.
A variable can be changed during query navigation only if it is used exclusively in a drilldown-characteristic, and there are no further restrictions to the characteristic other than this variable. There must be no additional characteristics with variables compounded to the characteristic you are working with. For variables for hierarchy nodes, the hierarchy must be determined uniquely and agree with the set display hierarchy.
Also, if the characteristic value
is moved, for example (ZV000009 - 1), the variable is no longer able to be changed when navigating queries.
System Response
The entry ZV000009 Can be changed during query navigation is not applied.
Procedure</i>
None of the explanations given applies to my query - does anyone know if this feature does actually work in Integrated Planning 2004s ?
Thanks
Sue