Copying historical data into planinng area

[Former Member]

Hai,

"For performance reasons, SAP recommends that you copy historical data from infocube to a timeseries instead of reading it directly from infocube."

Please correct me if I am wrong,

timeseries in the above context is the planning area.

I create a generic export datasource from MSDP_ADMIN giving it a name "9aplan" and it should generate an infsource in RSA1> infosources> Unassigned nodes as 9aplan.

From here on, how can I load the history from the infocube lets say, sales, to the infosource?

Should I create a transactional(realtime) infocube and then load data to it from both SALES and 9aplan?

Then how can the system access this cube when planning? where is it specified?

Thank you.

[somnath_manna · Accepted solution]

Hi Vishu,

A Planning Area is the structure - you need to initialise the "timeseries" against a planning version which will allow the data in keyfigures to be stored.

Loading data from the infocube to planning area - timeseries does not require any BW structure. Just use transaction /SAPAPO/TSCUBE to copy the Sales history data from the cube to the required keyfigure in the planning area (for the given version - most often being 000).

Hope this answers your question.

Thanks,

Somnath