Approving the plan data

[Former Member]

Hi There,

Scenario:

I have a scenario where a person "A" keys in the plan data, and person "B" is a manager who has to review the plan data keyed in by the Person "A". "A" can REJECT or APPROVE the entries.

I cant use the DATA SLICE since by nature the lock will be on the INFOPROVIDER LEVEL. Other input queries been built on the same infoprovider will get impact.

Please throw some insights how to achieve using the IP tools (planning functions / FOX ) for my business scenario.

Thanks in advance

Srini

[Former Member]

Hi,

You can add an infoobject in your aggregation level to store the status of rows (new, approved, etc) and set the value to new in your input query, and give managers a query to display such rows.

you can also check http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a05666e5-91bf-2a10-7285-a80b7f5f7...

http://scn.sap.com/thread/3368726

hope it helps.

[Former Member]

Hi Anass,

Thanks for your reply.

I will check this option in the system.

Regards

Srini

[cornelia_lezoch]

Hi Srini,

there is no real tool inside BI IP for aprovals.

I usually work with a copy of data and a marker-characteristic.

You can also use what Marc is describing here

http://scn.sap.com/community/data-warehousing/business-planning/blog/2008/09/15/how-to-implement-pla...

regards

Cornelia

[Former Member]

Hi Cornelia,

Thanks for your reply.

My requirement is to collect the manual data entry for one of my KPI, and I am using the BW-IP tool so the data entry can be done thru the portal. This solution is already implemented and working fine with command "SAVE_DATA" functionality of WAD. The end user entered the incorrect data and the stakeholder only realized when it was available as a KPI in the DASHBOARD. To avoid such an error stakeholder requested to have control so that to ensure the correct data goes into the Transactional cube.

I thought of having one more button "APPROVE" where stakeholder can click this button if the data is correct. But I am trying to find a solution how I can play around this button with command options of WAD.

Let me know if you have any suggestion for this approach.

Thanks

Srini