Show TOC Entering content frame

Procedure documentation Extracting Data from a Planning Area Locate the document in its SAP Library structure

Use

There are two purposes for which you might follow this procedure:

     For ad hoc reporting for planning area data

     To save data persistently to the database

Procedure

...

       1.      Generate an export DataSource for the planning area. To do so, proceed as follows:

                            a.      On the SAP Easy Access screen, choose Demand Planning ® Environment ® Administration of Demand Planning and Supply Network Planning.

                            b.      Select the planning area and, in the context menu, choose Change/Display.

                            c.      In planning area maintenance, choose Extras ® Generate DataSource.

A dialog box appears in which you enter a name for the data source.

                            d.      Choose Execute.

A screen with details for the data source appears.

                            e.      Specify the fields that you want to be able to select later for reporting purposes. This step enables you to limit a query to specific objects or ranges of objects. Your selection here does not influence the fields that are included in the export structure. Select the Suppress field indicator for the fields (InfoObjects) that you do not want to transfer.

Note

The number of fields that you transfer directly affects performance. Therefore, we recommend that you only transfer those fields that you require for reporting purposes in the InfoCube.

The field for the planning version is selected by default; you cannot deselect it. This means that you must enter a planning version in the InfoPackage later.

                              f.      Make a note of the DataSource name.

                            g.      Choose Save.

       2.      Replicate the DataSource. To do so, right mouse click the source system and choose Replicate DataSources in the Data Warehousing Workbench. In this case, the source system is the system in which you are performing Demand Planning. For example, if you are planning in the SAP SCM system, client 002, the technical name of the source system is APOCLNT002.

When the system messages at the bottom of your screen cease, a background job is triggered. Check in the job overview that this job has finished before proceeding to the next step.

       3.      In the Data Warehousing Workbench, you are still in the source system view. Right-click the source system and choose DataSources Overview in the context menu.

       4.      Assign an InfoSource to the DataSource: To do so, proceed as follows:

                            a.      In the DataSource overview under Data Marts, select the DataSource and choose Assign InfoSource from the context menu.

                            b.      In the dialog box, choose Create.

                            c.      In the next dialog box, enter a name and a short description for the InfoSource.

                            d.      When the InfoSource has been created, choose Enter.

                            e.      Answer the system prompt with Yes.

This saves the InfoSource/DataSource assignment.

Note

If the above procedure is unsuccessful, use the following alternative:

      Switch to the InfoSource view.

      Create an InfoSource (right-click a suitable InfoArea and choose Create InfoSource).

      Right-click the InfoSource and choose Assign DataSource from the context menu.

A dialog box appears with an overview of all DataSources in the Data Mart, including the export DataSources you have generated yourself.

      Select the DataSource you created in step 1.

       5.      In the Data Warehousing Workbench, branch to the InfoSource view.

       6.      Right-click the InfoSource that you have just created and choose Change.

The screen in which you can specify the assignment of the communication structure to the transfer structure appears. You see the communication structure in the upper half of the screen and the transfer structure in the lower half. Some of the assignment information is proposed by the system. You must fill in the missing information.

Note

This is another opportunity to remove superfluous InfoObjects from the communication structure. See also step 1.

       7.      Define the assignment of the communication structure to the transfer structure. To do so, proceed as follows:

                            a.      In the lower half of the screen, enter the source system and the DataSource for the transfer structure.

                            b.      On the Transfer Structure tab page, copy the objects from the DataSource to the transfer structure (from right to left).

                            c.      Click the Transfer Rule tab page.

                            d.      Check where the assignment of transfer structure fields to communication structure InfoObjects is not proposed by the system.

                            e.      Where the assignment has not been proposed:

                                                  i.       Include new InfoObjects in the communication structure in the upper half of the screen.

                                                ii.       In the lower half of the screen, select the new InfoObjects in the communication structure on the left and copy the InfoObjects to the appropriate fields in the transfer structure on the right.

                              f.      Choose Activate.

       8.      If you need an InfoCube to carry out reporting with a BI front end, create an SAP Remote InfoCube, specifying the InfoSource that you created in step 4 as the InfoSource.

Otherwise, see the note below.

       9.      Activate the SAP Remote InfoCube.

Result

In the SAP Business Explorer Browser, you can now create queries based on this SAP Remote InfoCube. See also Structure linkAd Hoc Reporting on Data in a Planning Area

Note

If you want to copy planning area data to an InfoCube for backup purposes or to save old planning data, create a basic InfoCube during step 8 (for example, by running program /SAPAPO/TS_PAREA_TO_ICUBE) and proceed as you would when uploading data from an ERP system or a flat file.

 

Leaving content frame