Hi friends,
I changed our Cognos 10 Model to DQM and getting the following error as a part of one of my Subject Queries.
RSV-VAL-0010 Failed to load the report specification. XQE-PLN-0203 With respect to query subject '[Presentation View].[REF]', the combination of a) the effective SQL generation being "As View" and b) the query subject using multiple facts, is not supported.
Could you pls help if you have faced this issue. I checked my model and I have not checked the As View option under the Governer.
Works fine in Cognos 10 CQM but not in Cognos 10 DQM.
Thanks a lot!