As soon as the user in Query Studio does something that is not possible with the model an error message is displayed. This is of course logical.
However it is a message like:
"An error occurred while performing operation 'sqlPrepareWithOptions' status='-120'."
And if the user hits "Details" he gets:
"UDA-SQL-0458 PREPARE failed because the query requires local processing of the data. The option to allow local processing has not been enabled.UDA-SQL-0475 The OLAP function 'sum' contains a clause (AT or PREFILTER) that is not supported by the database. This operation requires local processing of the data.RSV-SRV-0042 Trace back:RSReportService.cpp(758): QFException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp" etc etc... You all know the drill :)
Obviously, this is not something I want to confront my end users with.
Is there a way to display more user friendly error messages?
You could try the LDK (Language development Kit) with which you can customize the messages presented by Cognos....
Why not just enable Limited Local processing so the user does not get the message in the first place?
This was just an example :)
So fixing this "issue" will still leave some of the other items open.