Skip to Content
0

Best design approach. From bw transformations to IP fox formulas.

Mar 22, 2017 at 06:13 PM

112

avatar image

SCENARIO

Our client has some power users who are able to use RSA1 transaction, run infopackages and DTPs to some infocubes.

User’s target is to load/transform some data from one infocube to another.

The core abap code/logic is stored in the transformations built between infocubes.

This process is usually executed in some steps previously arranged. So there is a pseudo data flow that user/business knows and follows.

SYSTEM

We are working on SAP BW 7.5 ON HANA.

TARGET

To take advantage of HANA performance and speed.

To develop a Business Administration Cockpit to allow users to manage all these steps from one single application. Ideally users will know after every step if everything went fine and will continue with the next step using the same application”

Avoid users to work with RSA1 transaction: We want to avoid users to have to delete requests when something goes wrong and to have to use “manage infocubes” to review if data load was correct or not.

SOLUTION APPROACH

Write IP Planning functions replacing the current Abap code stored in the transformations.

Use as much as possible Fox formulas to be able to push code into HANA.

Use as a main framework or application Design Studio. The idea is to show or provide some buttons step by step where users can launch the ip planning functions and know if everything goes correct receiving a confirmation message or a list of detail messages explaining what was wrong.

QUESTIONS AND DOUBTS

Do you know any best practices recommended by sap in order to change all the abap code from transformations and use IP planning functions? What about using Fox formulas? Do you know any best practices published by sap? Is it at all the good way that we are trying to approach – get rid of transformations and replace them with Planning Functions?

Would you recommend Design Studio as a main framework/application to be used for running IP planning functions? Do you see better alternatives to Design Studio?

What do you think is a better option, Analysis for Office using planning functions or Design Studio? Or perhaps is a better idea to stay with existing ABAP transformations?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers