Query not running after draging more than two objects.

system · November 13, 2009, 11:09am

hi all,
I have category, subcategory and many other tables and Calculations is the table which contains all measures like unit_sold,Revenue etc.Now I want to drag category name,Sub-Category name and Revenue and run the query.But there is error as shown below:-
A database error occured. The database error text is: [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared… (WIS 10901)

AnushreeD (BOB member since 2009-11-13)

system · November 16, 2009, 10:00am

Did you try running that query directly on your database? Also, if you could post the query generated, it would help.

nithya_raj (BOB member since 2007-02-03)

system · November 16, 2009, 3:36pm

I’ve gotten that error when there is an error in the SQL syntax for one of the objects. If you have access to the universe, I suggest checking the format of the syntax for each object in the query, and running the query through the database if necessary to check syntax.

bkaporch (BOB member since 2008-12-02)