Execute planning function in Web template for selected row in analysis item

[#1]

Hello all.

I have been trying several different solution for this issue I have, but could not ,make it work. Hopefully, any of you can give me some ideas.

Initially the scenario seems to be easy.

I have a Web template were I show a query analysis item with costcenter, plan/act type, user and entry date. I allow single record selection in this item.

I have a button that should execute a planning function from the plannig modeler.

The planning function should be executed only for the costcenter and plan/act type which are selected in the analysis item.

How do I have to link the two objects :analysis item and planning function, so that the planning function is executed with the correct filter? What should be the filter definition (if any expecific things to consider)?.

Thanks in advance for your help.

Best regards,

Alfonso.

[Former Member]

Hi,

Check out this link, you can find sufficient details over here to work on your requirement. http://help.sap.com/saphelp_nw70/helpdata/en/45/e301089d574a88e10000000a155369/frameset.htm

I myself have tried out this and it works perfect.

Regards,

Deepti

[alfonso_gonzalez2]

Dear Deepti.

Thanks a lot for your answer, but it did not solve my issue.

The problem is that my query is not created over the same agregation level as the planning function is, and as per the link you have sent me it seems to be a prerequisite.

Is there any other way to do it?

More in detail, I am implementing a Lock/Unlock mechanissim for planning costcenters. I have a n ODS where I store my costcenetr status(lock or unlock) and I also have a cube where the planning values are stored.

My query(to select the costcenter to unlock) is done from the ODS, and my planning function is done in an aggreagation level of my cube (this is to lock the costcenter in cube, to avoid incorredct updates while it is unlocked/locked).

The issue that I have is that I can not find a way to send the selected information from the query to the planning function.

I hope you have more ideas.

Thanks a lot.

[Former Member]

Hi,

You can create your query on ODS and planning function on the aggregation level. The filter created on aggregation level is used to pass the selected costcenter. When you sleect a costcenter in analysis item it is passed to filter web item in WAD which is further passed to planning function.

Try it and let me know if you face any problem.

Regards,

Deepti

[alfonso_gonzalez2]

Dear Deepti.

Thanks again for your quick answer.

I finally solved my problem, more or less how you were proposing. The issue that I found is that when using the "Execute a Planning Function (Simple)" command, the binding does not work, but when using the "Execute a Planning Function" and setting each single characteristic, then it works and the value of the costcenter is moved to the plannig function.

Best regards,

Alfonso.