Skip to Content
0
Former Member
Sep 04, 2007 at 04:15 AM

Planning Functions - Binding Variables - Alternatives?

99 Views

Hi

I have also posted this in the 2004s forum but had no takers so hopefully this is the place to post.

We are on SPS 11 and are having some difficulties getting our Planning Functions to execute corerctly in the web templates.

I have created a simple planning function that performs a distribution.

The Planning Function works as expected using the plannning wizard and ristricts the data based on the Filter that I have created on the Aggregation Level as well as the Planning Function Selections.

I have created a query and web template that contains the same restriction as the filter in my aggregation level. The Agg Level filter / planning function and Query Filter all contain the Hierarchy Node Variable ZN_CC1 for the standard Cost Center Hierarchy.

I have created the following 4 Planning Buttons to test the execution of the Planning Function in the Web:

1. Planning Function Simple. Binding ref to the DP_1 (Query), Variable = Hierarchy Variable ZN_CC1, Planning Function ZDistrib1.

2. Planning Function Simple. Binding ref to the DP_1 (Query), Variable = Variable Input String Default ZN_CC1, Planning Function ZDistrib1.

3. Planning Function Simple. Binding ref to the DP_1 (Query), Variable = Hierarchy Variable ZN_CC1, Planning Function ZDistrib1. Display variable property selected.

4. Planning Function Simple. Binding ref to the DP_1 (Query), Cost Center Characteristic Data Provider Selection Default, Planning Function ZDistrib1.

When the query is executed and a node representing a group in the hierarchy is selected the query is executed and is input ready for the selected group. This is a subset of the hierarchy.

When the above planning fucntions are executed the following results display.

1. The planning function is executed however it is not restricted to the selection based on the hierarhcy variable node selected by the user. The planning function is executed for the entrire hierarchy. It is not restricted by the cost center hierarchy node variable value.

2. The planning function is executed however it is not restricted to the selection based on the hierarhcy variable node selected by the user. The planning function is executed for the entrire hierarchy. It is not restricted by the cost center hierarchy node variable value.

3. The variable popup displays and a hierarchy node is selected. The planning function is executed however it is not restricted to the selection based on the hierarhcy variable node selected by the user. The planning function is executed for the entrire hierarchy. It is not restricted by the cost center hierarchy node variable value, that was entered when prompted.

4. The planning function is executed however it is not restricted to the cost center selection based on the query DP1. The planning function is not restricted by the cost center selections.

HOWEVER,

If I goto to the filter web item and edit the cost center filter by selecting and adding all available cost centers to the filter. (This list of cost centers is restricted to the cost centers subordinate to the hierarhcy node selected in the variable)

When the above the planning functions are executed the function is now restricted to the cost centers added to the filter as explained above.

If anyone has had a similar issue with Planning Functions executing for data outside of the Dataprovider Selections I would be interested to know how you managed to get the planning function to retrict to the DP Selections that include hierarchy node variables.

If anyone from SAP can comment before I raise this as an OSS issue it would be much appreciated.

Thanks in advance.

Ian