writing planning area results into infocube

[former_member205751]

Hi team

there are ways to copy infocube stuff into planning area with ease.but the other way around is difficult and a rare case indeed....i guess so !!..i tried nook and corner of google  searching for clues to  write planning area results to infocube but i couldnt find any ......any clues from you would make me feel good...DB can you come to my rescue...

[Former Member · Accepted solution]

Rahul,

When you searched through SAP online help,  I guess you must have overlooked SAP's guidance in this matter.

http://help.sap.com/saphelp_scm700_ehp02/helpdata/EN/e0/9088392b385f6be10000000a11402f/frameset.htm

To accelerate your journey, you might want to consider taking a class.  I took

https://training.sap.com/v2/course/scm226-configuration-of-demand-planning-scm-apo-classroom-097-us-...

a few years ago, and it was well worth the money.  I am sure you can find a similar class in your vicinity.

Best Regards,

DB49

[former_member205751 · Accepted solution]

well DB when things come ready made on a platter from trainers...it doesn't give a "kick"..this kind of investigation ...constructing from clues..... gives a real thrill...a sort of "high"...guess i continue with my investigation

[former_member205751 · Accepted solution]

So its done ! !  DB having taken an intial idea from your material and an intense support from partners I completed configuring all by myself  ....my sincere thanks to you

[babu_kilari4]

Hello Rahul,

Yes. This can be done.

Unlike the data copy from Infocube to Planning Area, this requires a bit of BW expertise. If the data target is Infocube, you need to implement the following steps to get the data from Planning Area to Infocube.

1) You need to delete all the Indexes on the target Infocube

2) Delete the contents of the Infocube

3) Delete the contents of the PSA table

4) Create an Infopackage that takes the data from the Planning Area to Infocube ( Before doing this, you should set the planning area as your Data source )

5) Create a DTP against the above mentioned Infopackage that takes the data from Data Source to the Infocube

6) Once this step is done, you need to rebuild the indexes on the Infocube for better performance.

Hope this helps. Please let me know if you need more details on this. This is a very common scenario that is widely using in all the APO projects.

Babu Kilari

[former_member205751]

your ideas sounds good....let me  give a try...thanks for your inputs...will get back to you

[former_member205751]

yup babu ...i have created a planning area,activated it,generated a datasource ,and replicated the datasource  .....as of now fine....

so now it boils down to activating the datasource 9AENGI  and the logical system SAPCLNT800 ...i am attempting it now....with rsa5  but the system says "" man i dont find your datasource 9AENGI at all ""

i will try all ways at my disposal...and get back to you

[former_member205751]

Success  !  thanks babu

[Former Member]

hi Rahul,

you are not talking about Backup of Planning area data (from Livecache) to Infocube, are you?

[former_member187488]

I think so. He's taking about backup planning area data to infocube. Acutally it's a very common process in APO. We suggest regulary backup data into infocube in case of data inconsistency or data loss at liveCache side. And the process is particular important when you need to de-initialize the planning area to eliminate some inconsistencies.

[former_member205751]

yup sandeep i am trying the same...somehow i struggled  and almost nearing the solution...finally system is asking me to activate the snpclt100  and infocube.....guess once its done i will able to do the backup....ada am taking the same.....""I think so. He's taking about backup planning area data to infocube. Acutally it's a very common process in APO. We suggest regulary backup data into infocube in case of data inconsistency or data loss at liveCache side. And the process is particular important when you need to de-initialize the planning area to eliminate some inconsistencies.""'

well sandeep ,ada....i will take some more  struggle with the inputs i got from ADA previous replies ....let me see  .if nothing works ....let me know the structured way of doing it...