Skip to Content
0
Feb 07, 2012 at 08:50 PM

Inner Join between 2 SAP BW Tables

79 Views

Hi,

I am trying to create an universe to join 2 BW tables. I am using "Information Design Tool". I have created a JCO connection for each table (cube) and a Data Federator joining them.

As result of this join in Data Federator, I got this SQL:

SELECT

"IIACCO_O1"."CA_ACCNT",

"DCA_PLTINS"."CA_PLTINS"

FROM

"DCA_PLTINS" INNER JOIN "IIACCO_O1" ON ("CA_ACCNT"="CA_ACCNT")

WHERE

"IIACCO_O1"."CA_APPLIC" = '8'

I just create a join between "CA_ACCNT" that exist in both tables. A simple join, with n:n relation.

So, I was expecting that BW server ran a SQL just like I described above, but instead of execute just one simple SQL, BW runs two selects:

SELECT

"IIACCO_O1"."CA_ACCNT"

FROM

"IIACCO_O1"

WHERE

"IIACCO_O1"."CA_APPLIC" = '8'

SELECT

"DCA_PLTINS"."CA_PLTINS"

FROM

"DCA_PLTINS"

In other words, it does a fulll table scan in the second table and I don't know how to solve this.

Could anyone help me? What should I do to make BW undestand that it needs run just one select?

Tks.