How to limit precalculator resources?

[Former Member]

Hi all,

we want to precalculate some data using process chains. The problem is, that this nearly occupates all sap processes so that the system is nearly unuseable for the users.

Is there a possibillity to limit the resources the precalculation server can use on sap side?

We are using a multiprovider so I think, this is the problem why so much sap processes are used when precalculation runs ...

Is there a possibility to change this behavior?

Thank

you.

Best regards

Christian

[Former Member · Accepted solution]

Hi Christian,

please check the "Wiki home of the Broadcasting precalculation"

http://wiki.sdn.sap.com/wiki/display/BI/WikihomeoftheBroadcasting+precalculation

There is a document which scetches a possible solution. Please note that instead of using report RSRD_BROADCAST_STARTER please use report RSRD_BROADCAST_BATCH. This mean create a process chain which executes settings using report RSRD_BROADCAST_BATCH, add another process chain step which waits for a certain amout of time (e.g. ABAP report which executes WAIT UP TO XX SECONDS), add a process chain step which executes settings using RSRD_BROADCAST_BATCH, add another wait step and so on ...

Could you please check this?

Regards Matthias

[Former Member · Accepted solution]

Hi Matthias,

I checked the wiki and your documentation, nice stuff.

You mentioned that I should create lots of process chains, that not very useful.

Is there no way to say the broadcaster (or SAP) do only run a broadcaster job if no other is active? If some is running, then wait?

By the way what happens if there is more than one broadcasting setting selected for RSRD_BROADCAST_BATCH? Would it run in parallel, or one after an other?

Hey, this should work: use report RSRD_BROADCAST_BATCH using batch class A and there is only one class A batch...

There is only one problem, this only work for this report ... not for other triggered precalculations... Which leads to my questions again.

Thank you.

Best regards

Christian

[Former Member · Accepted solution]

Hi Christian,

if you start multiple settings in the selection-option in report RSRD_BROADCAST_BATCH there are run in parallel. Well you can select less precalculation server instances. For example if you use the multi service instance precalculation server you can for the system to execute the settings in "sequential order". Just define one precalculation server in RSRPRECADMIN. The first settings which precalculated sets the precalculation server to busy and no other setting can be executed until the current setting has been finished. As soon as the current settings has been finished the server is ready to take the next setting. As you can see this is "sequential" although you can not determine the order in which a setting is processed. The drawback is that you may end up with a lot of failed setting. They failed because they could not be scheduled with in the time frame, because the precalculation server was busy all the time. Nevertheless the failed settings can be reprossed using report RSRD_BROADCAST_BATCH or RSR_PREC_SETTINGS_RESTART. This way you process less settings in parallel (in this case only one). But I think this is not what you want.

Another way would be to set some of your precalculation server artificially to "offline". But this is something I can not recomend.

Regards Matthias

[Former Member · Accepted solution]

Hi Matthias,

we are using RSRD_BROADCAST_BATCH to manage precalculation. It seems that it works fine. There are two processes running parallel, and a third is sleeping ... don't know why, but this do not use too much resources on our system.

Thank you.

Best regards

Christian