COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: vasudev_jain on 29 Sep 2020 01:54:28 AM

Title: Rank function not working in Charts .
Post by: vasudev_jain on 29 Sep 2020 01:54:28 AM
Hello Experts ,

I hope you all are fine !!

As I am new to Cognos and i am stuck with a thing -

I  want top 10 values of a measure which will be reflected in pie chart in Cognos 11 DMR model , so i tired using Rank function over the measure as a another data item (say Data item1 )and filtering it out (Data item1<11), it is giving me correct data when doing view tabular data but as soon as passing in chats it is throwing me error "Found an internal error: java.lang.IllegalMonitorStateException" .

Realized that relational functions are not working in DMR model in charts and graphs   (Please correct me , if i am wrong anywhere.)

Tried using Functions Head, Top count, but did not worked out , Can you guys please guide me .

Thanks
Vasudev

Title: Re: Rank function not working in Charts .
Post by: vasudev_jain on 16 Oct 2020 01:35:25 AM
Hi Everyone ,

Was able to resolve the issue .

Rank function not working in Charts  but working in list was the limitation of Cognos 11.0.13 version which were using , Now working on Cognos 11.1.7 , rank function seems to be working fine .

Regards
Vasu