COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: zgeorge on 03 Apr 2019 07:24:41 AM

Title: Cognos rank function with cubes
Post by: zgeorge on 03 Apr 2019 07:24:41 AM
Hello!

I've been asked to incorporate a rank of the top product we sell into one of our reports. I've noticed that since I've used the Rank() function, it has slowed down the report tremendously. I've read a few different sources saying you can use Rank() on a dynamic cube and some recommending I don't. If anyone can provide more information on this, it would be extremely helpful!

Best,
Zach George