Skip to Content

Query on Merge dimension feature in webI report

Hi All,

Merge Query :

Case 1: One data provider contains year (2002,2003,2004) ,sales and other data provider contains year ( 2005,2006) ,purchases.

If we apply merge , what is the output of year ,Is it like 2002,2003....2006 ?

Case 2: One data provider contains year (2002,2003,2004) ,sales and other data provider contains year ( 2002,2003,2004) ,purchases.

If we apply merge , what is the output of year ,Is it like 2002,2003,2004 ?

Thanks

Ram

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 30, 2017 at 07:16 PM

    In first case you will get 2002,03,04,05 & 2006.

    in second case 2002,03 and 2004.

    see attached link for more expample.

    https://blogs.sap.com/2013/12/04/merge-dimensions-and-extended-merge-in-webi/

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Amit,

      Please let me know the solution for below few queries .

      1.The default maximum parallel queries parameter value is 4 , but If our webI report contains five tabs/five queries , how parallel query execution works in database end ? Are queries run in parallel or serial ?

      2.The default maximum parallel queries parameter value is 20 but CMC web intelligence processing server 'Max. parallel queries parameter is 10 , in this case ,which parameter value will prefer and execute ?

      3.End user wants to see ,where exactly parallel query execution happens that means ,If end user asks ,where do we check parallel query execution on the database or some where ? Is there any tool to check this like data federation tool.

      Please do the needful

      Thanks

      Ram

  • avatar image
    Former Member
    Jan 30, 2017 at 06:42 PM

    Hi Ram,

    Yes , the output will be same as you are suggesting in your post.

    It will work like Full Outer Join.

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks Pandey\Amit,

      One thing , Is it mandatory to merge the common dimensions which we got from multiple data providers for parallel query execution ?

      Do we use same universe as multiple data providers ?

      Suppose ,If we don't have common dimension which we got from multiple data providers , how to proceed for parallel execution ?

      Kindly give me some example ,If possible .