cancel
Showing results for 
Search instead for 
Did you mean: 

Simple APO scenario

Former Member
0 Kudos

I'm planning for a scenario where i want to load the data from a flat file into BW of APO and do the demand planning based on that data.

So, any one can help me with the sample data flat file i can use for this scenario?

-Anika

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Anika,

Process steps for data Flow process of extracting data from Flat file.

Flat file Format is like this....

Product Location Planning Version Fiscal Year Period Fiscal Year Variant Key figure Unit

1.Prepare Excel file(CSV format). In that you enter your info objects as said above.

2.Double click on data Source from modelling & Chose Source system for Flat file.

3.Create Application Component.

4 create Data Source ( choose Transactinal data source),in that in Extraction Tab , you suppose to enter path of flat file,then Select data format CSVFLCONV(CSV Format) then enter comma in Data seperator & Escape sign ".

5.Then go to Proposal & press load example data field so that in field you will get automatically all Info objects.Then in field you enter all tech name( say 9amatnr,9alocno etc) of info objects under Info objects template coloumn & activate it.After activation you will find all the excel data in preview Tab.* Note that your excel file should not open on desktop.

6.right click on activated data Source & Create Info package & give same path in Extraction tab.

8.Double clikc on Info sources from Modelling which is located at left hand side.

9.Right Click on Application Component & Create Info Source

11.While creating Info Source system genrate one Pop up in that you shoud enter Info Source Name & description & in copy from Field you suppose to select Data Source which you have created earlier.

12.then Copy all the info object from Data Source & paste it in to Info Source or by pressing info object pushbuttton you can select all the info object automatically one by one.Activate the info source.

13.Right Click on Infosource & Create transformation for Data Source & info Source in that your source system is Data Source & target System is Info Source.Activate the Transformation.

14.Double clikc on Info Provider from modelling& Create Info Area.

15.Right Click on Info Area & create Info Cube.

16.In Dimension1 you suppose the all characteristcs which is avilable in info Source,same way you suppose to enter all key figure & Time characteristics.for doing this you right click on Diemension 1 & select direct Input,so that you can enter Characteristics in that.

17.Activate Info Cube.

18 Right click on Info Cube & Create transformation for Info Cube & Info Source.In that your Source should be Info Source & target shoud be Info Cube.

19.Then double clikc on Data transfer process which will come after successful activation of Trasformation between info cube & info source.

20Cretae Data Transfer Process.

21.After succesfull creation of Data Flow process,double click on Info Package & go to scheduling & execute.

22.Right click on Data Source & go to Manage.You will find the request in green or Yellow status.If yellow status is there,then select that request & press refresh,after some time this convert in to Green.

23.Then double click on Data Transfre process & go to last tab i.e execute & execute.

24.after that you have right click on Info Cube & got manage,you wil find reuest in green Status or yellow status,press refresh until reuest should be coverted in green status.

25.Select that request & go to content

26.Execute the transaction,you will find the data.

Hope so above steps will help you to crete Data Flow process & see the data in to info Cube.

Regards

Sujay

Former Member
0 Kudos

Thanks Sujay and Sai. I'll try these steps and let you know guys.

Can we do some thing simialr with PP/DS and/or SNP and/or GATP or TPVS or do we need to have CIF/ECC 6 mandatory for them?

Thanks,

Anika

Former Member
0 Kudos

make an excel file in the following way:

Product Location SalesOrg Version 0calmonth Sales History

PR1 LOC1 SO1 000 200710 100

PR2 LOC2 SO2 000 200711 50

create such entries say 75-100 and save the file as .csv format and in BW make sure you have following characterstics and keyfigure in your Infocube (9AVERSION will be in DP not in BW) and as wellin your POS and PA of DP

hope this is clear

Edited by: sai balakavi on Oct 22, 2008 1:43 AM

Former Member
0 Kudos

Please go to building blocks and create/test scenario as per your requirement.

http://help.sap.com/bp%5Fscmv250/

Go to -.

Technical Information ->

Building Block Library

For BW:

http://help.sap.com/bp_biv370/html/index.htm

Also Suggest you to Visit WIKi page, lots of good stuff:

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/scm/main

Manish

Edited by: Manish Kumar Rathi on Oct 21, 2008 7:28 PM