Outer join error in universe

[Former Member]

Hi,

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

Thanks,

Eswar

[Former Member]

I've tried changing the parameter ANSI 92 to yes in universe again and it worked now.

thanks