Skip to Content
Author's profile photo Former Member

Business Objects 4.0 SP2 UNV to UNX Conversion Join Issue & Solution

Business Objects 4.0 SP2 UNV to UNX Conversion Join Issue:

After Converting the Universe from UNV to UNX:

a)     1) The Inner Join will become Left/Right Join.

E.g. Join between the V_DWH_GEOGR_ORG_HIER_TER_DIM and V_DWH_GEOGR_ORG_DIM is Inner Join in the UNV format. After Conversion to UNX Format this Join will become Left Outer Join. See the Screen shot after conversion to UNX.

/wp-content/uploads/2013/11/1_331627.jpg

Strange thing is that if you open the UNX Universe and see if there is any Left Outer Join created, you will see that there is no Left Outer Join in the Universe; still it is coming as Left Outer Join in the Report! See the below Screenshot.

/wp-content/uploads/2013/11/2_331633.png

b)    2) There will not be any Left or Right join in the Universe.

                                                                                                                                       

If we compare the UNV and UNX Universe, all Left or Right Outer Join which is in UNV Universe will become Inner Join in the UNX Universe.

Business Objects 4.0 SP2 UNV to UNX Conversion Join Solution:

After Converting the Universe from UNV to UNX:

 

Step 1:

Go to Data Foundation Layer of UNX Universe and you will find List of all the joins in the Universe. Double Click each of these joins to edit them and just Click “Ok” without changing anything. This will make all these joins back to Inner Join.

E.g. After Applying the Fix mentioned above the join between V_DWH_GEOGR_ORG_HIER_TER_DIM and V_DWH_GEOGR_ORG_DIM will become Inner Join in the Report. See the below Screenshot.

/wp-content/uploads/2013/11/3_331634.png

Step 2:

Compare the UNV Universe with UNX Universe and Fix all the Left/Right Outer Join. In UNX format there will not be any outer Join.

We need to look at the UNV and implement the same in UNX by ticking the same table as in UNV. As there will be very less number of Left/Right Outer Joins it will be less time consuming task.

Once these two steps are completed all the Join Issues will be Resolved.

Assigned tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo satheesh Menon
      satheesh Menon

      Nice Article!!

      INFORMATIVE

      Author's profile photo Former Member
      Former Member

      Great Info Sumesh.

      Author's profile photo Former Member
      Former Member

      Good blog Sumesh, Thanks for posting this.

      Author's profile photo Former Member
      Former Member

      informative...

      Author's profile photo Former Member
      Former Member

      Nice Article!!

      Author's profile photo Former Member
      Former Member

      Good Info!!

      Author's profile photo Kailas Kurup
      Kailas Kurup

      Will definitely check this out

      Author's profile photo Former Member
      Former Member

      good good 🙂

      Author's profile photo Former Member
      Former Member

      Nice Information Thanks for Sharing.

      Author's profile photo Former Member
      Former Member

      Hi, This happen only for Universe that has specific reporting data source or for all universes?

      Is this issue fixed in new version?

      Author's profile photo Former Member
      Former Member

      Useful one...

      Regards

      Subbarao