Chart report, data item is not getting used in the chart but filter has to happe

[xyz]

Hi All,

I am using Cognos 11.0.6, where my package is DQM enabled and database is Oracle. We have migrated reports from 10.2 to Cognos 11.0.6. After DQM is enabled few our the reports are not working erroring out with different errors. I am getting below error.

XQE-PLN-0093. The argument at position 1 of 'for' from the data item 'Total Volume' is a 'value' expression, which cannot be coerced into a 'set' expression.=== Please see http://www.ibm.com/search/csass/search?q=XQE-PLN-0093 for more information ===.

The chart report earlier before converting it from relation to dimensional, is ranked based on Total Volume for Carrier Names and gets filtered based on value provided in the value prompt. Where Total Volume is placed in the Default measure (y-axis) section and Carrier Name in the Categories (x-axis)

So, I have convert the report against dimensional functions, which should meet with the relational output earlier. I have created a Rank equivalent function as below, which I can not use directly in the chart.

topCount([Carrier ID], #prompt('Select Top Carrier Count (ex : 10)','int', '0')#, [Total Volume]) 

I have added as a property to Carrier Name data item of x-axis. But whenever I change the prompt value for different rank, chart is not filtering, is there a way, I can filter the chart?

Can you please let me know you suggestions/solution or guidance on the same.

Your help will be much appreciated.

Thanks & Regards,
XYZ