creating a left outer join between two data providers

building reports desktopintelligence
1

Hello All,

I have a report that contains data from two data providers. The main data provider is an oracle universe and is also my default universe. The second data provider is a dbf file. The dbf file contains additional columns that need to be included in the report and I have linked the two data providers via a common dimension. The problem is that the link seems to be a full outer join (meaning all data from BOTH data providers are included in the report). All records from the dbf file that don’t match a corresponding record from the oracle universe are showing up at the end of the report.

Is it possible for me to change it so that the link is an left outer join instead? That way, only the oracle universe will dictate what is displayed in the report.

TIA!

xarax (BOB member since 2005-03-28)

2

No, not directly. But there is a workaround – take a look in our FAQ: Reporter (Frequently Asked Questions) – How can I make a table from two data providers and only show data common to both?

Anita Craig :us: (BOB member since 2002-06-17)

3

Awesome!

Thanks for the link and your help.

xarax (BOB member since 2005-03-28)