Drill through in Cross tab not working in the latest Cognos version 11.1 R1

[xyz]

Hi,

A data item value placed in Crosstab rows, on which drill through is enabled, wherein in drill through definition passing data item value to one of the parameters, data item which is getting passed, has a case statement, is not working as expected and the report errors out saying after reaching target report saying RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-16'. UDA-SQL-0358 Line 93: Syntax error near "between". Because the source value it is passing is Member Unique name instead of relevant Level name. Even the target report filter have a case statement which expects the Level name from the data item value, whereas Member Unique Name is getting passed. It has been working in older Congos versions like 11.0.6 and 11.0.9 even though Member Unique name is getting passed in the drill through definition, but in this latest Cognos version 11.1 R1 issue is happening in the Crosstab, but if I put the same data item in list and test, drill through is working as expected.

Tried to pass the data item in the properties of Cross tab node members still report is failing to pick the Level name. Still the issue didn't get resolved.

Tried the to change the different options in the Property to pass for the data items, still it didn't work.

Follow the below steps to replicate the issue.

1) Drag and drop a cross tab and in the rows of the crosstab, drag any dataitem in crosstab rows and apply drill through
2) In the drill through definition pass data item value to one of the parameters, where data item value has case statement in it.

Can you guys please let me a know if you have any workaround/suggestions?


Thanks & Regards,
XYZ