Skip to Content

SAP BW BPS 3.5 Limitations

We are setting up a planning area for 90 users with 2000+cost centers and cost elements .

Setting up a environment to budget and forecast with up-to 12 versions of forecasts.

I wanted to understand the performance implications of using BPS for the above planning purpose..

one of them I identified was ...

the planning package closes at around 50000 records and the records are no longer available to be edited .

so if user is working on one record and the package is closed he will no longer be able to edit the same record....

he will have to create another record and then send a delta update ....this is time consuming and not what the users want ....

does any one have a work around for this problem.....

Also please discuss various other limitations of using BPS.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 08, 2011 at 03:33 PM

    Whether a request is closed or not has absolutley no impact on whether a record can be edited or not. Where did you hear this? It is incorrect information.

    BPS (or IP) always sends a delta record when an entry is changed (assuming the original entry was saved).

    For example, if a record is created with value 10, and then saveet. Subsequently, the value is changed to 15. BPS will write a +5 record with the same characteristic values to the cube. It will do this if the request the data is contained in is open or closed.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello

      In continuation to the above questions I need a clarification on one point.

      We have 10 cost center managers with each having auth to 5 different cost centers.

      They continue to do the planning in the planning area...

      one user has planned for the 5 cost centers for the entire fiscal year....he has around 500 records ........

      Each time he opens his planning area he can see these records .....and add new records if necessary ...

      My question is now if the planning package closes after the specified limit of 50000 will he continue to see the 500 records in the area ?

      If yes , can anyone explain on what basis the records are displayed to the user .....?

  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2011 at 10:32 AM

    Firstly understand that a Planning package like a Planning Area or Level is just a structure. Planning package is not opened or closed. When you enter data into any of the input layouts a request is created for that InfoCube. This is like any BW data loading request. Only difference is this request will stay open till it gets to say 50000 records. So it is displayed in Yellow and once it gets closed it gets displayed in Green. The request staying open does not affect the records getting stored in the Cube as well as the retrieval of the same records in the layout.

    As an experiment change the mode of the cube to dataloading (this will close the open request if any). Then change back to planning mode. Enter a few records. Then you can repeat the above activity of changing modes. Go to manage for the real time infocube that was affected. You will see that the latest recor will have exactly the same number of records that you entered.

    If you changed any existing records then you will find that count on the no. of records updated.

    Hope it helps. Assign points if this was useful.

    Thanks.

    Rohit

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.