Show TOC

 Exchange of Data Between InfoCubes and Planning Areas

Use

You store permanent data in InfoCubes. In general this is either historical actual data or forecasts that you want to keep for future comparison. Current data for planning is kept in LiveCache in planning areas. Demand Planning itself is conducted in LiveCache. You need to transfer data between the two, for instance to use historical data as the basis for forecasting.

Note Note

When designing your planning area, remember that although placing a lot of a data in LiveCache improves performance it requires more memory.

End of the note.

Features

Importing Data into Planning Areas

There are basically two methods of importing data.

  • If you want have permanent access to the data

    When you assign key figures to the planning area, you enter the InfoCube from which the key figure is taken. This forms a permanent link between the InfoCube and the planning area.

  • If you only want to copy data occasionally from an InfoCube to the planning area

    You use the function Loading Data from an InfoCube into a Planning Area . A similar function is Copy Management , which allows you to copy between planning areas and versions.

Exporting Data from Planning Areas to InfoCubes

There are two possibilities here: You can export directly as described in Extracting Data from a Planning Area (move mode)or using indirectly DataStore objects as described in Updating InfoCubes Using DataStore Objects (delta mode).

With the second method it is easier to update InfoCubes. If you export directly there is the danger that you copy the same data time and time again to the InfoCube. You can avoid this by using DataStore objects.