Custom ABAP Program for BW 3.5 Loads Data into a Transactional InfoCube Automatically

  • by Charles Hall, SAP NetWeaver BI Solution Consultant, Sapphire Consulting
  • March 1, 2008
Although users of SAP NetWeaver BI 7.0 can switch an InfoCube between load and plan modes, the process is manual in SAP BW 3.5 and earlier. Find out how you can mimic the SAP NetWeaver BI 7.0 functionality in four steps with the supplied ABAP program.
Key Concept

In SAP BW 3.5 and earlier, transactional InfoCubes allow you to write data to them. This differs from a standard InfoCube, which you use mainly for read-only access. In SAP NetWeaver BI 7.0, these InfoCubes are called real-time InfoCubes.

In some situations, you may need to load data into a transactional InfoCube for planning. This could be an approved budget coming from SAP ERP Central Component (ECC), a file upload of budget data created outside of SAP NetWeaver BI, or actual data that you use as the basis for plan data.

In SAP NetWeaver BI 7.0, you can switch the InfoCube in a process chain between load and plan modes automatically. For SAP BW 3.5, you can mimic this functionality by using a custom ABAP program. You insert the program into a process chain to switch the transactional InfoCube to batch mode before you load the data.

I'll show you a method to automate and schedule data loads to a transactional InfoCube. You can also use this method to close the open request on a transactional InfoCube on a periodic basis, such as nightly. Furthermore, by switching the InfoCube prior to and after the execution of a planning function, you can use this program to segregate results at certain stages in the planning process or to encapsulate the results of a planning function.

Charles Hall

Charles Hall is a certified SAP NetWeaver BI solution consultant with more than 10 years of experience working with SAP solutions. Charles has been working with BW and SEM for the past five years and specializes in Integrated Planning and Business Planning and Simulation. Charles currently lives in Atlanta, Georgia.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.