Hi,
we have FM model with 2 databases of progress openedge 11.4 using two DSN in Cognos 10.2 and we applied filter in one of the query subject using 'in' operator like querysubject1.column in (querysubject2.column). here query subject1 belongs to one data base and another query subject belongs to another database.
when we are validating this querysubject, we are getting the below error and if we delete the filter, it is working fine.
RQP-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-0333 The table "PUB.tablename" was not found in the dictionary
please suggest me to fix this issue.
thanks.