0 Replies Latest reply on Aug 2, 2016 7:03 AM by AbinashBehera

    Taking distinct values on basis of three columns in OBIEE RPD

    AbinashBehera

      Hi All,

       

      I have a EMPLOYEE table as following :

         

      col1col2col3col4col5
      ARN-0001MUMBAICASH101CH
      ARN-0001MUMBAICASH102CH
      ARN-0001MUMBAICASH103CH

       

      I also have a Sales table as :

         

      fac1fac2fac3fac4
      ARN-0001MUMBAICASH1000
      ARN-0002MUMBAICASH2000
      ARN-0003MUMBAICASH3000

       

       

      Now I am joining these two table on the basis of col1=fac1 AND col2=fac2 AND col3=fac3 in RPD physical layer and defining inner join in BMM layer. I want to display the sales(fac4) for 'CH'(col5), So as it is inner join its taking all three combinations available in EMPLOYEE TABLE and its multiplying the value three times, but I want to take only one combination of the three columns from EMPLOYEE TABLE.

       

      Please put some light here. How I can take only distinct values.

       

      Thanks,

      Abinash