Loading Demand plan data from APO to BW

[Former Member]

Hi Gurus,

We have requirement as below.

we have to extract two key figures from APO to BW system

The 2key figures of APO will get data as below:

First key figure has to hold Yearly snap shot and 2nd Key figure has to hold QTY snapshot.

we have constrained production plan & sales plan keyfigures in apo demand planning and the requirement is to extract these 2 keyfigure quaintest into BI.

Data Example as below:

KF1: Yearly snapshot

KF2: Quarterly snapshots

Yearly data means from Jan to Dec and

Quaterly data is as below

Qtr1 - Dec JAN to Dec

Qtr2 (in FEB) - Mar to Dec

Qtr3 (in May) - Jun to Dec

Qtr4 (in Aug) - Sep to Dec

so please let me know to how to handle or extract these data into BW.

Thanks,

Shailaja

[Former Member · Accepted solution]

Hi Shailaja

Are these two KF's production plan & sales plan keyfigures lies in same Planning Book? If so you can create that Planning Area as a Data Source, and try to load this data into a cube in APO BW. From that Cube you can easily extract to Stand alone BW system.

Thanks

Venkat Gorla

[Former Member · Accepted solution]

Hi Venkat,

Yes, both the key figures are ther in the same planning area.

But my question here is how to get that data into BW? meaning...

If APO/DP does the planning in the month of Sep 2010 for Jan to dec 2011 and the

values are like

Sep-10 jan Feb mar april may june july aug sep oct nov dec

15 14 13 11 10 11 12 16 14 15 22 20

Dec-10 12 14 16 18 29 20 18 15 14 12 17 20

Mar-11 10 12 13 14 15 16 17 18 20

Jul-11 20 40 30 40 50

meaning, If the planning is done in the month of Sep 2010 for the yr 2011 as explained above that values should be extracted into BW and the next planning will be done in the month of Dec 2010 again for entire yr of 2011 i.e. Jan 2011 to Dec2011.

But the values should be captured as they are.. that means if i use DSO the values from request1 to request2 will be over written n if i use the cube they will be added up..

Request1 will hold data of Sep2010: planning data

Request2 wil hold Dec 2010 data ....n req3 will hold data of Mar 11...

but users want to see the values or planning figures as they are.

Hope i made my requimrent more detailled.

Please let me know the solution to get the data as it is in BW.

Thanks,

Shailaja

[Former Member · Accepted solution]

Hi Sailaja,

Yes You are correct,

if you are using the conventional BW extraction, to DSO or CUBE data will be overwrite / summarized depending upon the Key field combination of an InfoProvider (DSO / CUBE).

In APO all Planning activities will be based on your Planning Month and Your Planning Version (By default it is 000).

So we need to maintian Planning Month as a Character ( based on Calmonth) in MPOS which will be used as a Key Filed in Cube.

Assume that you have done your plannnig in the month of Sep 2010, Then this planning month CHAR will hold the data as 092010.At the end of the plannig cycle load this data to one back up cube ( In this cube Key field should be planning month).

and you have done next planning in the month of Dec 2010, then this CHAR will hold the data as 122010 which is different from your 092010.at the end of this planing cycle load this data also into Backup cube.

This Backup cube will contain the data of Both Sep as well as Dec planning cycle. As you said here the data will not be summarized / overwrite because the key combination is different, when you check the data in LISTCUBE give the planning month as a selection parameter then you will be able to see the data for all the planning months.Here the values will be captured same as they are in LC.

Hope it is clear now.

Thanks

Venkat Gorla

[Former Member · Accepted solution]

Hi,

You neeed to have one CHAR as Reporting month/Planning month in your DSO as key field.

It will keep the month inwhich data is enter for all CALMONTHs.

It will help you keep alll the data and to maintain historization.

In all your reports you need to have selction on this "reporting month" or by default you may value in this.

This CHAR can be pupulated by writing small code at trasformation.

I hope it will help.

Thanks,

S

[Former Member · Accepted solution]

Hi Venkat,

Thanks for ur reply..

I will try this approach and update the results in this post ;)...

Thank you !!!!

Shailaja

[Former Member · Accepted solution]

Hi Venkat,

I did confirm with my APO team that they do send or BW has to pull the data from APO five times as explained ib my example.

That means Ky1 will be planned for entire 2011 and KeyFig2 for Quarterly plan data which will give data to BW for 4 times.

So total 5 extractions from APO to BW and APO will decide the planning date for the same.

But Could you please explain me in detail about the process or Steps from APO to BW for my above requirement?

And i want you to update you that once we get the planning data into BW we need to send the data as it is into ECC system.

i would also want to know that the data volume will effect the perfomance in BW?if that is the case i think once the planning data is updated to ECC team then i can delete the planning data from BW.

Thanks alot for ur reply...

Thanks,

Shailaja

Edited by: Shailaja Badda on Aug 20, 2010 10:44 PM

Edited by: Shailaja Badda on Aug 20, 2010 11:30 PM

[Former Member · Accepted solution]

Hi Sailaja,

Please clarify me how frequently you are pulling the data to BW. I mean is it daily / weekly / monthly. In a normal practice we used to pull the data into BW once in a month i.e after the current month planning cycle. based on this we can create a Key Characteristics.

In your project where the back up data is storing? is it in ECC or BW?

If you delete the data from BW server, data will not be available for your future analysis based on the history data.

so it is advisable that we need to store the data in BW itself.

Thanks

Venkat

[Former Member · Accepted solution]

Hi Venkat,

actaully the data BW is going to get from APO is more useful for ECC team. So ECC Team said that once they extract the data from BW, ECC team said that BW can delete the data once ECC Pulls the data from BW to ECC.

So thats the reason I did update you that i want to delete the data fro BW once ECC gets the data.

As you said i will maitain the BackupCube , So please give me the steps to pull data from APO to BW and and send it back up cube etc.,.

Thank you !!

Shailaja

[Former Member · Accepted solution]

Hi Sailaja,

If the Business prefers to keep the data in ECC, thats fine right.

Steps for Data Extraction:

1.* Generate the Planning Area as a Data Source*

2. Once the PA is converted as a Data Source then you can use this Data source and cretae transformations to a cube.

3. By using conventional BW extractions method you can easily pull the data into one Cube in APO side.

4. Once the data is loaded into Cube, Generate this Cube as a Data source

5. In BW side, use this Generated cube as a Data source and pull the data to BW.

Please let me know if you need anything more, here iam unable to upload the document for step by step procedure with screen shots.

please let me know your id i will forward it to you if required.

Thanks

Venkat Gorla

[Former Member · Accepted solution]

Hi Venkat,

My id is shailajanathatgmail.com

or u can view my id in my businesscard in sdn.

Just click on my name then it will show my details.

Please send the Doc to my Id .

Thank you!!!!!

Shailaja

Edited by: Shailaja on Aug 24, 2010 7:39 PM

[Former Member · Accepted solution]

Hi Sailaja,

I have sent the required document to your id. Hope this will solve your problem. Once your problem got solved please close the thread.

Thanks

Venkat

[Former Member · Accepted solution]

Thanks for the docs.

Regards,

Shailaja

Edited by: Shailaja on Aug 26, 2010 7:17 PM

[Former Member]

Still need clarification

[Former Member]

Hi,

I guess if you will take quarterly snap shot key figure only then it will satisfy you need for year as well. As when you will add four quarter numbers then you will get yearly numbers.

In this case you may have TIME chars as "Quarter" & "year" amd load this key figure with both the va;ues so when you will see data on year you will get total of four quarter and quarterly data is already available.

If you need both keyfigure to be loadede then created two similar DSO wuith different views (Quarterly and Yearly). Load the quarterly key figures in one DSO and Yearly in other DSO. Map both in cube as per your reporting needs.

I hope it will help.

Thanks,

S