Skip to Content
0

Functionality of parallel query in Web Intelligence report

Jan 25, 2017 at 07:14 PM

551

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
AMIT KUMAR
Jan 25, 2017 at 07:22 PM
0

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/

Show 7 Share
10 |10000 characters needed characters left characters exceeded

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 ?

0

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

1

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 ?
1

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.

0

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

0

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.

0
Show more comments