I'm having an issue with a measure I'm trying to build in a business layer built off of a multi source data foundation. The select statement in the measure is a 12 line case when statement, with one line per month. The issue I am hiving is the it works fine when I include 8 rows Jan to Aug, but when I include a 9th row i get the following error message when I try to show values.
[Data Federator Driver] [Server] [Connector 'BIQL'] The database has reported an Exception: [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQLState: 42000, Vendor code: 8,180)
The backend database is sql server 2008 and I'm using and ODBC connection. Additionally it does work if I use an OLE DB connection it just take 5 to 10 times longer.
Any assistance would be appreciated.