equi-join in Webi?

Home Forums SAP Business Objects equi-join in Webi?

Tagged: ,

This topic contains 4 replies, has 2 voices, and was last updated by Profile photo of sami sami 5 years, 3 months ago.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #3363
    Profile photo of Malik
    Malik
    Member

    In a situation where you have two queries.

    car yr buyers car yr sale
    honda 2005 31k honda 2006 1.2m
    honda 2006 33k honda 2007 1.4m
    toyota 2005 32k toyota 2006 1.3m
    toyota 2006 34k toyota 2007 1.5m

    we only want the matching values to show..

    car yr buyers sale

    honda 2006 33k 1.2m
    toyota 2006 34k 1.3m

    how do we do this on the report level? merged dimensions won’t work.. cuz they will either be left-merge or right-merge rite?

    waiting. thanks

    #3365
    Profile photo of sami
    sami
    Member

    Malik, Use intersection queries in Webi query panel when you are first creating the report. You use an intersection query to obtain data common to two sets of results.

    #3366
    Profile photo of sami
    sami
    Member

    Sorry forgot to add this. Please reference page 29 in the following PDF;

    http://www.girlscouts.org/gstechcon10/Advanced%20Data%20Analyzer%20Techniques.pdf

    #3367
    Profile photo of Malik
    Malik
    Member

    many thanks Sami
    ¬†Is there some manual that shows “how to” do the intersection queries

    #3368
    Profile photo of sami
    sami
    Member

    Oops, my apologies. I meant page 144 of the following user manual:

    http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_ia_en.pdf

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.