I have a date field "Date" in a fact table. I create a caculation which is Max_date= max(Date) and try to use the filter Date=Max_date in the query subject. I get the following error when testing the query subject.
QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-16'.
UDA-SQL-0327 An invalid object name was detected in the SQL request.
UDA-SQL-0328 Unable to find the column "D2.C29".
Interesting thing is that a similar filter works for another query subject. If I just include these calculations in the query subject, it works fine. As soon as I try to filter on these I get the error. Cognos support site says that the error means that the report is corrupt. But I am getting the error in FM itself...
Any ideas?
Thanks a lot,
H
It's a guess, but I think the problem is the word 'Date', you've used it as a fieldname, but it's probably also a reserved word in your database. So when querying the database it tries to use the date (function, constant or whatever) instead of seeing it as field.
Gz
I figured out a way without using the filter on the model... thanks for the suggestions