need to load the data through excel for plan data through IP?

[Former Member]

Hi all,

The user needs to load the data through the excel and click on the save button so that the data is saved in the cube through integrated planning.

The objects used are

customer, material, plant, calendarmonth sales qty, gross billing!!

Can anyone pls let me know how to do this?

Thanks

[Former Member · Accepted solution]

Hi.

In addition you can create simple data entry screen with required objects and copy-paste data from excel according to the next [howto|http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/80220fed-0e6d-2b10-bbb9-f6af76dee0cc].

Regards.

[Former Member]

Hi,

You can use the following How to guide to load data from file into transactional cube.

If using IP :

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/90cef248-29e0-2910-11bb-df8dece7e...

Can also Refer to Marc's Blog:

/people/marc.bernard/blog/2007/11/25/how-to-load-a-file-into-sap-netweaver-bi-integrated-planning-part-1

If you are using bPS you can get the details in Wiki also for the same.

You can then create the hyperlink in Excel ,which user can use to upload data which can then be saved to cube using save button.