extraction of the data from the planning area

[Former Member]

We have been trying to extract the planned data from the planing area into an remote info cube. we have configured the remote info cube and have gone through the steps and have been able to extract the data in the remote info cube without running any program.

Does that mean that we don't have to run the program /SAPAPO/TS_PAREA_TO_ICUBE for the loading of the data from the planning area into the outbound cube.In case we have to run this which is the place to find it.

what is the standard way of exporting the data from the planning area into the outbound cube.

[Former Member]

and am not sure it is mentioned in the steps above remember to replicate the data sources in order to get the data from the planning area updated

[Former Member]

Hi APO APO,

You don't specifically need to run program /SAPAPO/TS_PAREA_TO_ICUBE. You would just need to build a Basic Infocube to store your data. The program /SAPAPO/TS_PAREA_TO_ICUBE (which can be run in SE38) can help you build a cube whose structure is similar to your POS+PA but you can do this manually in RSA1.

The data flow would be different depending on the version your are in. It is also slightly different if your BW system is an external one (e.g. different from your APO system).

In SCM 5.0 / BI 7.0 the flow would be:

PA->Export DataSource->Transformation Rules->InfoCube

You will then need to build DTPs (and probably InfoPackages if needed) to schedule the load.

In SCM < 5.0 / BI <= 3.5 the flow would be:

PA->Export DataSource->Transfer Rules->InfoSource->Update Rules->InfoCube

You will then need InfoPackages to schedule your loads.

You might also to insert an ODS in the flow (probably located in the APO system). The ODS might help you extract delta records from the APO system to the BW system. However, the decision of whether or not to insert an ODS depends on whether delta records would really help (VS the added run time of loading and activating the ODS).

Remote Cubes are advisable if the data volume is low. However, if the volume of data is large, then it is advisable to load the data to a Basic infocube first and then do the reporting from there. Using a Remote Cube also have headaches (e.g. when you have implemented BADI /SAPAPO/SDP_EXTRACT you have to make sure computations are still correct even if the users have decided to hide/swap some columns in the query).

Hope this adds some info.

[somnath_manna]

Hello Bob,

The report /SAPAPO/TS_PAREA_TO_ICUBE is used to create an Infocube based on a Planning Area. Earlier you had to manually create an Infocube for backing up data from a Planning Area. using this report that has been automated with the system now creating the infocube based on the characteristics and keyfigures of the planning area and its associated Planning Object Structure. It is the same report that can be accessed from the Planning Area in transaction /SAPAPO/MSDP_ADMIN >> Extras >> Data Extraction Tool and Click on the Data Backup button.

But you still need to create the Export DataSource, Infosource, Update Rules and Infopackage for carrying out data extraction from the Planning Area to this Infocube.

Thanks,

somnath