I have used a derived table in a universe create using Information Designer Tool(UNX). When i run the report using the thick client, Web Intelligence Tool, it works fine😊.
However when i run the same report through the thin client, Launch pad, i get an error related to ODBC connection😭 (i have forgotten the error message,😉 will update the post with error message, tomorrow morning)
I am using SQL Server 2008 as the database which gets connected to the Universe using an ODBC DSN, SQL Server Native Client 10.0
When i checked the query, it has the double quotes around Derived table name. Could this be causing a problem?😕
While setting up the ODBC connection, i saw a setting as "Use ANSI quoted identifier" could this be of help?
Appreciate any ideas to discuss and understand the problem.