7 Replies Latest reply on Nov 29, 2016 4:11 PM by 2934998

    OBIEE RPD Question

    2934998

      Hi,

       

      I need to join a new table to an existing fact table and a dimension join with the following scenario:

       

      Dim A
      1
      2
      3
      Fact
      1
      2
      3
      Dim B
      1
      3

       

      Fact -> Dim A

      Fact -> Dim B

       

      In my report i want to show all the records from dim A but wherever it matches with Dim B have a *, how can we implement this in RPD? So the output in Publisher i am looking for is:

       

      Output

      1*

      2

      3*

       

      Any help is appreciated

       

      Thanks,

      Nimesh