Skip to Content
author's profile photo Former Member
Former Member

DS-Can we perform 'or' oper while taking Relationship reports b/w 2 joins

Hello,

I have two tables. I have to take relationship profile report b/w these 2 tables.Problem is while taking profile report i have to compare one column of table with two columns of another table.I have given two joins.But if i join like that,it is performing 'and' operation b/w two joins.So my report is wrong if it perform 'and' operation.I have to perform 'or' Operation.Is there any way to change the default operation 'and' to 'or'.

Please suggest me,it is very urgent.

Regards

Vishnu.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2011 at 02:23 PM

    Hi Vishnu,

    Views work on Joins and Join means AND not OR. So these sort of functionalities can be achieved by writing a FM.

    Also you can try this if your scenario contains only the below logic.

    Say suppose you have two tables TAB1 and TAB2

    TAB1 has Feilds F1...F10

    TAB2 has Fields S1...S10

    Now create a View V1 on Tab1 and Tab2 and mention the condtion TAB1-F1 = TAB1-S1

    Now create a View V2 on Tab1 and Tab2 and mention the condtion TAB1-F1 = TAB1-S2

    then Create a View V3 on V1 and V2 and mention condition V1-F1 = V2-F1.

    Create a DS on top of View V3.

    Hope this helps,

    Aparna Duvvuri

    Edited by: Aparna Duvvuri on Nov 18, 2011 7:53 PM

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi aparna,

      Thanks for your reply.The question i posted is belongs to sap business objects data services, i don't think the views you mentioned can be created in data services.I have created tables instead of views,but it is not working for my situation.I have to take relationship profile report using two relationship by comparing one column in tab1 with 2 columns in tab2.I know the join performs 'and' operation,but while writing sql we can compare two columns using 'or' operation using sql language.That's what i need.Do you have any idea, is that can be performed in data services, please suggest me.

      Regards

      Vishnu

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.