Skip to Content
Former Member
Apr 13, 2010 at 05:45 AM

Outer join error in universe



I'm using BO XI R3.1 and database is sqlserver2005. When i try to use the outerjoin in universe it is throwing the error as mentioned below. I"ve also set the ANSI-92 parameter as Yes under universe parameters but still no luck.Could any one please advise.

Exception: DBD, [Microsoft OLE DB provider for SQL server]: The query uses non-Ansi outer join operators ("=" or "="). To run this query without modification, please set the compatibility level for current database to 80 or lower, using stored procedure sp_dbcmptlevel. It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN). In the future version of SQL server, non-ANSI join operators will not be supported even in backward-compatibility modes.State: 42000