Skip to Content
0

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

Jan 25, 2017 at 04:49 PM

135

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.

2 Answers

Cornelia Lezoch Jan 30, 2017 at 03:53 PM
0

Hi David,

there is no general answer to your question.

i would make it dependent on the number of users usind it, the data volume that needs to be copied and the locking problems that could occurr during the process.

For the frontend - I usually prefer web to excel, so formerly it was the WAD, now needs to be the DS.

depending on the logic that is used in the transformation, it might be possible to put it all into one fox.

what can go wrong during the transformations today? If you run a planning function - it will only write data if no error occurs ...

regards

Cornelia

Share
10 |10000 characters needed characters left characters exceeded
David Sanz Alaminos Mar 22, 2017 at 05:11 PM
0

Hi Lezoch,

Thank you very much for your reply and sorry for being late in my response.

Indeed it is a difficult question, and we do not have a clear path to follow yet.

We are still looking for ideas or best approaches.

Best regards,

David

Share
10 |10000 characters needed characters left characters exceeded