Entering content frame

Procedure documentation Creating InfoCubes for Use in Demand Planning Locate the document in its SAP Library structure

This graphic is explained in the accompanying text

You can create InfoCubes manually as described below or use report program /SAPAPO/TS_PARAE_TO_ICUBE to generate a new InfoCube from the planning area automatically.


  1. In Data Targets in the Administrator Workbench, select the InfoArea you previously created and choose Create InfoCube from the context menu.
  2. Enter a name and a description for the InfoCube, select the InfoCube type, and choose Enter.
  3. If asked by the system to choose between APO and BW, select BW. You never actively create APO InfoCubes.

  4. In the Edit InfoCube: Characteristics screen, select from the template the characteristics you want to include in your InfoCube and copy them to the InfoCube using the Transfer fields button.
  5. NoteInclude 9AVERSION. The APO system is preconfigured to store planning versions in this characteristic.

    NoteSAP recommends that you include the same characteristics that you have in your master planning object structure. Do not include characteristics that you defined as attributes in the master planning object structure.

    Note Include 9AMATNR for products and 9ALOCNO for locations. Characteristics prefixed with '9A' fall within the standard APO name range.

    NoteUse conversion routine PRODU for the characteristic that represents products.

  6. Click on Dimensions to define at least one dimension. Dimensions allow you to group your characteristics according to different business perspectives. For example, you might have a Geography dimension and a Product dimension.
  7. NoteYou do not need to create dimensions for time characteristics, units or data packets; these are created automatically.

  8. Click on the Assign tab to assign the characteristics to dimensions
  9. Select the characteristic(s) you want to assign, use the scroll buttons to select the dimension to which you wish to assign it (them), and click on Assign. For example, you might assign the characteristics Region and Customer to the Geography dimension, and the characteristics Product family, Brand and Product to the Product dimension.

    Note Assign the characteristic 9AVERSION to a dimension named Version.

    Choose Continue.

  10. Click on the Time chars. tab to edit the time characteristics.
  11. The Edit InfoCube: Time Characteristics screen appears.

    Select time characteristics from the template. SAP recommends that you include the same time characteristics as you have for periodicities in the storage buckets profile of the planning area.

  12. To include key figures in your InfoCube click on the Key fig. tab.
  13. The Edit InfoCube: Key Figures screen appears.

    Select from the template the key figures you want to include in your InfoCube and copy them to the InfoCube using the Transfer fields button.

    NoteIf you wish to use this InfoCube to back up planning data as well as to store actual data, include all the key figures whose data you wish to be backed up. For information on data backup, see Structure link Extracting Data from a Planning Area.

    However, you should not use InfoCubes for storing your current planning data. The performance of the LiveCache is markedly better.

    NoteTo create new key figures, choose Environment ® Key figures ® Create. For monetary amounts, select Amount, and enter the data type CURR and the unit/currency 0STAT_CURR or 0Currency. For quantities, select Quantity and enter the data type QUAN and the unit 0BASE_UOM or 0Unit.

  14. Choose InfoCube ® Activate.
  15. Choose Back.





Leaving content frame