Skip to Content

Functionality of parallel query in Web Intelligence report

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 25, 2017 at 07:22 PM

    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/

    Add comment
    10|10000 characters needed characters exceeded

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