Full outer Join On GreenPlum Tables

building semantic layer
1

Presently i am using BOXIR4 and Greenplum as database, i have one requirement of implementing a full outer join between two Greenplum tables. I sit possible to implement full outer join at universe level with Generic ODBC or Greenplum4 ODBC drivers as data connectivity layer

satyapeddi :india: (BOB member since 2011-01-10)

2

You’ll need to change your odbc.prm file and your universe parameter

odbc.prm change:

ANSI_92
YES

Universe parameter change:
ANSI_92 = YES

3

Thanks a lot for your reply and your Support Mark, Its working

satyapeddi :india: (BOB member since 2011-01-10)

4

No problem, thanks for confirming resolution :slight_smile:

5

Hi Mark,

I am also facing a similar situation in BI 4.0.

I am a little confused hence could you please provide a step by step description of how to use Outer join with Greenplum database.

Sincerely appreciate your help.

Regards,

MT

mihirmt (BOB member since 2012-08-23)

6

The changes are documented above. What part of them don’t you understand?

7

Hi,

Sorry I saw your update but was busy with something else.

What I need to know is, I will go ahead and make the changes to the prm files as described by you, but then will I be able to create an outer join directly in the universe ? or do I have to follow any workaround such as modify the generated SQL to execute outer join?

I am not a BO developer but a BO Admin, hence its taking sometime for me to understand this. :hb:

Appreaciate all your help ! :slight_smile:

Regards,

MT

mihirmt (BOB member since 2012-08-23)

8

Yes, you should be able to.

You may want to check you can before telling others that you can though - also others may have to change the prm file on their machine if they are universe developers (send them your copy and get them to replace theirs with it).