Parallel processing – dashboard do not run queries in parallel

[Former Member]

Hi Experts

We have upgraded to DS 1.5 and trying out the parallel processing functionality. What we have done so far:

1. Create a very simple dashboard and stored it in BO LaunchPad
2. Created two data sources based on two different BEx queries
3. Set the parameter Merge Prompts to False
4. Set DS_1 to Processing Group “1” and DS_2 to Processing Group “2”
5. When I run the dashboard with profiling (&PROFILING=X) I cannot see that it run in parallel. When analysing using Chrome developer tool it also looks to run sequentially.

The parameter for Number of Sessions for Parallel Query Execution (CMC setting) has not been added so this should not have an impact in the parallel processing.

Why doesn’t the dashboard run the queries in parallel? Are there any other settings that need to be done?

Kind regards

Erik

[Former Member · Accepted solution]

Hi all

I checked sessions in sm04 and it actually looks like it run in parallel, but this is not shown in the Profiling...

Erik

[Karol-K · Accepted solution]

Hi,

it is visible in the profiling, see the blog and its section Display of Processing Group Execution - the groups are listed in the profiling dialog.

and, it is NOT visible in the developer tool (http requests) as the parallel execution is not on HTTP level. see the blog .

Karol

[TammyPowlas]

Hello Erik - is the property for "load in script" on the data source set to "false"

When you are running the application, on the BW backend, have you run transaction SM04 to see that the sessions are being created?