BusinessObjects Board

Joins in the Merged Dimesions

When we merge two dimensions, it gives a full outer join between 2 data providers, but if required to have either left/right outer join using merged dimensions how can we acheive tht?


Zeenat :india: (BOB member since 2007-12-11)

This might help you.

https://bobj-board.org/t/139373


Prashant Purohit :india: (BOB member since 2009-02-18)

Thanks for the reply prashant, but in this ppt, i couldnt find anywhere about the question I have asked or the link tht you have provided (how we can implement different joins with merged dimensions),
in this ppt , it is mentioned how to merge the dimensions, what could be the possible errors one can get after merging dimensions in BO 5.x and 6.x and how we can remove the null values using equality join.

If possible can you please more elaborate it.


Zeenat :india: (BOB member since 2007-12-11)

A merged dimension will give you full outer join, if you are able to supress the rows with NULL value of either or both sides, you will be able to implement left outer join, right outer join or equi join.


Prashant Purohit :india: (BOB member since 2009-02-18)