Functionality of parallel query in Web Intelligence report

[former_member211289]

Hi All,

Kindly let me know , where and when can we use parallel query ?

Is this a database concept or universe/webI concept ?

Could any one explain the parallel query with an example ,If possible ?

Please do the needful with any doc/video of parallel query related

Thanks

Ram

[amitrathi239 · Accepted solution]

before BI 4.2 if in your BO reports you have two or more queries then they will run sequentially.means first query will run and then second and after that you will see consolidate data.

SAP released new feature from BI 4.2 to run queries in parallel. means instead of second query will wait to run both the queries will run in parallel.

benifit of this feature is it will reduce the refresh time.

Check attached link for more information.

https://blogs.sap.com/2016/01/22/new-webi-feature-in-bi42-parallel-queries/

[former_member211289 · Accepted solution]

Thanks for your quick response Amit,

Once I created the Question , you are the 1st person in my mind that you will provide the solution asap.

My query is ,Two or more queries means ,

For example , I have two objects ,can I treat these two objects as two queries ? If not

could you please share one example about two or more queries ,If possible Amit ?

[amitrathi239 · Accepted solution]

No,two or more queries means webi queries or multiple data providers (same meaning)..

[former_member211289 · Accepted solution]

Thanks Amit,

Lastly ,can you please explain the below sentences.

• There is no parallel activity at the refresh preparation (i.e. query script generation, resolution of contexts, and prompts) ......what does it mean ?
• Parallel queries will not be run for dependent data providers......what does it mean ?

[amitrathi239 · Accepted solution]

context/prompt (refresh preparation) means let say if you have two queries and same or different prompts in the both the webi queries then parallel activity will not work.prompts lov display will sequentially.

Dependant data providers means if output of first webi query object is passed in the second webi query then it's not going to work.

like in second webi query filter condition if you put condition like State in list "result from other/any query" option and select the first query object in the filter condition.in this case you have dependent webi queries.

[former_member211289 · Accepted solution]

Don't mind Amit,

Didn't understand the 1st explanation,

"context/prompt (refresh preparation) means let say if you have two queries and same or different prompts in the both the webi queries then parallel activity will not work.prompts lov display will sequentially."

Moreover , what will happen while query script generation , here also parallel activity won't work

[amitrathi239 · Accepted solution]

in simple terms for all these simple individual activities processed very fast but in background for all these activities no of rows/or you can queries are processed. For those parellel queryies will not work.

[former_member211289 · Accepted solution]

Thanks Amit,

Query on this statement "Parallel query execution to be performed when refreshing WebI documents with multiple data providers"

Query :

For parallel query execution or generally ,Is it mandatory to merge the common dimensions which were received from multiple data providers in webi report ?

If your answer is yes ,Suppose ,If objects don't have common dimension which we got from multiple data provider ,how to proceed ?

Do we use only one universe as multiple data providers?

Could you please provide the 'result from other /any query' option screen shot ?