Entering content frame

Procedure documentation Ad Hoc Reporting on Data in a Planning Area Locate the document in its SAP Library structure

Use

Follow this procedure to use Business Explorer reporting functions on APO planning area data.

Using MultiCubes it is also possible to report on planned data in APO and actual data in a BW system. For more information, see the SAP Business Information Warehouse documentation for Release 2.0B at http://help.sap.com/.

Prerequisites

  1. You have created a Remote InfoCube for your planning area. To find out how to do this, see Extracting Data from a Planning Area.
  2. You have defined a query in the SAP Business Explorer Browser. To find out how to do this, see the SAP Business Information Warehouse documentation for Release 2.0B at http://help.sap.com/.

Procedure

  1. Install a BW front end.
  2. On your Windows desktop, choose Start → Programs → SAP Frontend → SAP Business → Explorer Analyzer.
  3. This starts Excel.

  4. At the prompt, enable the Excel macros.
  5. In the Analyzer toolbar, click on the Settings This graphic is explained in the accompanying text icon and choose BW server connection.
  6. This causes a SAP Logon window to appear.

  7. Log on to your APO system.
  8. In the Analyzer toolbar, click on the Open This graphic is explained in the accompanying text icon.
  9. In the panel on the left, click Queries.
  10. Double-click on the query you want to start.
  11. Make a change in interactive planning and click the Refresh icon in the Analyzer toolbar This graphic is explained in the accompanying text

The updated data is instantly read from liveCache.

Result

You see the planning data in Excel, as well as a header showing the object selection to which the data refers.

Leaving content frame