Sunday, October 21, 2007

Error in Drill though Report

Hi All,
I am trying to run a drill through report from a cube. We are passing a set of parameters from the cube to the report which includes date range. This error is specific when you use data range in Drill through reports.
Error:
RSV-SRV-0032 - Unsatisfied parameter values are preventing the report from running. It is possible that a query used to populate a Prompt control depends on a parameter from either the report or the model.
Solution:
When i tried with the solution in the KB link, it is resolved. The solution is casting the date filter of the drill through report to date type.
The following Cognos KB link will explain about this error in detail.

No comments: