BO Universe Outer Join Problem
Posted on 2008-10-28
BOE XI-R2 SP-2
I have a big universe that's built off a Sql 2005 database that is set to Sql 2000 compatibility. ANSI-92 compatibility for this universe is set to "No".
I wanted to use CLR integration on this database the other day, so I set its compatibility to Sql 2005. But that broke many reports due to the fact that there are several joins in this universe that use the old-style outer join operators "*=" and "=*". So I had to set it back to Sql 2000 compatibility.
I've tried setting ANSI-92 to "Yes", which simply removes the "*" from these outer-join operators, making them inner joins (not what I need). But when I try to replace the old-style operators with LEFT OUTER JOIN or whatever, the BOE universe designer doesn't recognize those. Parsing the join fails.
I'm thinking--I'm HOPING--this is because I did not have all 3 mojos going at the same time: db set to 2005 PLUS the universe set to ANSI-92 PLUS the join operator being LEFT OUTER JOIN instead of *=. I only had the universe set to ANSI-92 with the LEFT OUTER JOIN syntax. (I had set the DB back to 2005-compatibility because I was killing some production reports).
Can anyone confirm this? Will it work when I have all 3 of these planets lined up? Or am I screwed somehow, being stuck at XI-R2 SP-2 indefinitely?