Invoke a planning function in BI-IP using a button to copy filtered data

[Former Member]

Hi All,

I am using a planning function type copy to create a new version of data in the infocube.

In Web Application Designer, I created a button that invoke my planning function using a command type EXEC_PLANNING_FUNCTION. So, I would like to copy the records displayed in my analysis item (that are filtered by some drop down items), but what is happening is that all records in infocube are copied instead of copying the data that is filtered by the drop down items.

Can you help me with any suggestion?

Thank you.

Bruno Rodrigues

[gergely_gombos · Accepted solution]

Hi Bruno,

I think it would be good if you create a planning sequence in your system.

The planning sequence contains one (or more) planning functions, and a planning filter.

In the planning filter you can restrict your characteristic values.

In the button, choose EXEC_PLANNING_SEQUENCE command.

If you create a good filter and create a planning seqence use the filter and the planning function your problem would be solved.

Hope it helps.

Best Regards,

Gergely Gombos

[Former Member · Accepted solution]

Hi Gergely,

Thank you for your response.

How I can use the planning filter to restrict for the values presented in the drop down boxes?

Best regards,

Bruno Rodrigues

[gergely_gombos · Accepted solution]

Hi Bruno,

"How I can use the planning filter to restrict for the values presented in the drop down boxes?"

You can create the filter which contain the characteristic which you use when created dropdown boxes.

You can add chararcteristics values in the filter, these values you will see in the dropdown box.

You can use the dropdown boxes to restrict the filter.

You can place the dropdown box (boxes) on your BEx workbook, and connect (with macro I think) to the SAP.

If you choose a value in the dropdown box and run the sequence, the sequence's filter will be restricted that value which you choosed.

Best regards,

Gergely Gombos

[Former Member]

check the link http://help.sap.com/saphelp_nw70/helpdata/en/45/e641e4c61256dee10000000a114a6b/frameset.htm and you will find your answer.