Q. How do I fix certain errors?”

A. You actually express 3 different problems. To resolve the first error, check that the InfoPackage is not loading directly into the InfoCube. Make sure that it is loading to PSA first before going into the cube.

-With errors 2 and 3, there shows to be a difficulty with whichever system is calling your client, and you should talk to your basis team to rectify RFC errors. If all attempts don’t lead to the desired results you probably will have to open an OSS message to SAP.

Q. Sales History for DP

“We are trying to remove the duplicate storage of sales history data in two positions and the consequent system overheads of loads and additional similar items. Is it always required to load sales history into APO or can it be stored in the central BW (non-APO) and referenced via a remote cube in APO?”

A. Becoming the Sales History put in APO does not necessarily mean that you have duplicate data. The center BW (non –APO) is the leading system where the Sales History is saved. The only purpose why it is “stored” in the APO-BW is to load it into liveCache. Typically Sales History in APO is modernized at the opening of each planning cycle (e.g. over the weekend) and the past weeks one is deleted.

-If you want to avoid having Sales Order History data saved in an InfoCube in APO you can use a remote cube in the APO BW. For example, the Sales Order History Cube is reported in the main BW System and a remote cube is generated in the APO BW system based on the Sales Order History cube in the main BW system.

Q. Special drill down

“In the data representation of the planning book, we have a number of key figures. When I drill down by product, I notice the first key figure and the product drill down. From there, the next key figure seems and the list goes on.

-I would like to swap the drill down between the characteristics and the drill down. Is there a way to change the format so that I can drill down by the product and show all key figures for each product instead?”

A. This is very simple to achieve because all you have to do is change the pivot sorting. You can do this by right-clicking on the name field of your planning table and select Pivot sorting.

-It might appear that Pivot sorting is grayed out. Then you have to make sure your header row is on and “Details All” is chosen for a characteristic, you’re for your product. This is required before the system will enable pivot sorting.

-In beginning APO versions, Pivot sorting couldn’t be saved and the users had to set up their sorting every time they started a planning book or loaded data. As of SCM 4.0, Pivot sorting can be saved user particular and as of SCM 4.1, even a Pivot sorting for key figures is possible.

-If your business process needs the users to drill down to the “work” level they either can use the interactive drill-down functions via the head or the shuffler or you can develop a macro that would take the user straight to the “right” level. As general, you should test the appearance of your drill downs.