Returning All Values

Chels12 · Mar 6, 2019 3:14PM

Hello,

I am new to using OBIEE(Oracle Business Intelligence 12.2.1.3.0). I am a front-end user. I am creating a report using two tables.

How do i create an analysis to return all values in Table A if not found in table B.

E.g

Table A have 20 records

Table B have 10 records

I need to return 20 records with the matching 10 records from Table B

Do i have to change the property?

Thanks

[Deleted User] · Mar 6, 2019 3:27PM

Create an analysis for all records in table B.

Create an analysis for all records in table A and filter "Based on another analysis" - and there you match for example "Table B.ID" = "Table A.ID"

[Deleted User] · Mar 6, 2019 3:45PM

...or are you talking about making a UNION of the two data sets and reutrn 30 rows or an outer join?

Chels12 · Mar 8, 2019 12:02PM

Thanks sooo much.

More like a Left Join on table A.

I am trying to figure out how to also return values(fields) from table B

Thanks!!!!!

===================================================================================================

Create an analysis for all records in table B.

Create an analysis for all records in table A and filter "Based on another analysis" - and there you match for example "Table B.ID" = "Table A.ID"

MFA for Oracle Community