Tuesday, September 16, 2008

Framework Required Filter in Cognos 8.3 RSV-SRV-0042

One thing I have been observing is that, in 8.2 when we have required filters to access the metadata we would again filter the same filter in a logic manner with the ‘Usage’ set to ‘Optional’. So basically what is happening here is that, we are using the filter once in the prompt page and a filter in the query also. But in the Cognos 8.3 it throws an error when I try to do it that way.
The error looks something like this.
Prompt 'beginning_AR_date' is used multiple times with conflicting data types
In Details
RSV-SRV-0042 Trace back: RSReportService.cpp(747): QFException: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(217): QFException: CCL_RETHROW: RSReportServiceMethod::process(): promptPagingForward_Request RSASyncExecutionThread.cpp(690): QFException: RSASyncExecutionThread::checkException RSASyncExecutionThread.cpp(204): QFException: CCL_CAUGHT:…….and goes on.

No comments: