SAP Design Studio 1.5: parallel processing & backend sessions

[nicolas_nevers2]

Hello,

I am using DS 1.5 SP02 and I created a Dashboard which uses many DSources causing issues in the backend server because of the number of RFC sessions running in the sametime (one per query).

I tried to fix that problem by assigning to each queries a "processing group" Under 'Data Binding" in the query Datasource properties

Let's assume I have 6 Datasources assigned to 2 different processing groups (3 queries assigned to PG1 and 3 queries assigned to PG2)

Each processing group should consume only ONE session in the backend server (BW transaction sm04).

I also disabled "Variable merge" by seting "Merge prompts" to false in the application properties.

When I execute the report through the LaunchPad I can see as many sessions (6) in BW transaction sm04 as I have queries (6).

This means that the grouping does not work and my problem is not solved as I am expecting only 2 sessions (one per processing group).

Any idea what I am missing in my configuration?

Thanks in advance for your help.

[TammyPowlas]

Hi Nicolas - have you seen the chart shown in Karol's document?

It depends on what your application is doing; could you check and report back? 

[nicolas_nevers2]

Hello Tammy,

I read that document that confirms my setup in DS 1.5

I do not understand your question. My application is rendering Actual data from BW into crosstabs and charts.

But I have too many sessions in BW backend and want to group the DS into processing groups but it does not work.

Any idea?

[Karol-K]

Hi Nicolas,

an application has always "main" session. And then one session per processing group.

In your scenario, you should see 1 session for the app, and 2 more sessions (as you have 3 DS / processing group -> 2 groups).

Of course, you see also the sessions from the designer. If you start the designer, there are also open session for this application in "design mode". This is probably why you see more than those 3.

Check your sessions in SM05, open new application in a browser and check then the difference.

Btw, as the main session is unused, it makes sense to put some data sources also into the main session (simply not assigning any processing group to eg. 2 data sources)

Karol