I think I've seen everything ever written about dynamic sorting in Cognos and still can't get it to work. Am I missing something in Cognos 8.4 having to do with this? I haven't seen many recent posts/docs.
I need to toggle back and forth from ASC and DESC on each column, I don't want to use up & down arrows (click on the column header to toggle), I don't want to use Jscript, and I'm using a cube as my data source.
I've been through 6 different iterations and cannot get the DESC list to render. I've used render variables, drill throughs to the same report, etc, etc.
All the docs I've seen are assuming a relational source, which is why I'm assuming my problem has to do with the dimensional source, but that's just an assumption. I've tried changing the macro type to MUN.
Any thoughts or suggestions would be greatly appreciated.