Skip to Content
Former Member
May 28, 2012 at 06:58 PM

Double quotes around derived table name in the universe


Hi Gurus,

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.