Friday, September 3, 2010

New Dynamic Sorting Controls from IBM Cognos

Cognos seems to have come up with new controls / method for dynamic column sorting that doesn't involve the drill through methods.

Here's the link to the article.

http://www.ibm.com/developerworks/data/library/cognos/reporting/scripting_techniques/page515.html?ca=drs-

Sounds cool!! Hope this ends the report re-run issues we have while using the drill-through method for sorting.

I will check this method out and post my comments later.

Let me know your thoughts on this method though.

Here's an update from PaulM about applying this method on Cognos 10 environment:

[User comments: PaulM]
There are some differences between the XML files from Cognos 8 to Cognos 10. The general structure of the files are the same, so making the correct updates is not difficult.

First you need to use a decent text editor, one with comparison capabilities. Notepad++ is excellent for this.

Open both the C10 version and the version from the download. They should be in different tabs in Notepad++. Click on the plugins menu and select Compare --> Compare.

Find and copy the differences related to this technique only. Don't try to copy deprecated objects over. All of the related fragments have "orderCol" somewhere in the name.
 

6 comments:

Anonymous said...

this works in Cognos 8. but what about 10? I copied all the 3 xml files but cognos 10 started throwing errors. Is there a different set of code for cognos 10?

Zephyr said...

Seems like the code was developed for Cognos 8. Don't have Cognos 10 to verify this. I think you should raise this with IBM.

CognosPaul said...

There are some differences between the XML files from Cognos 8 to Cognos 10. The general structure of the files are the same, so making the correct updates is not difficult.

First you need to use a decent text editor, one with comparison capabilities. Notepad++ is excellent for this.

Open both the C10 version and the version from the download. They should be in different tabs in Notepad++. Click on the plugins menu and select Compare --> Compare.

Find and copy the differences related to this technique only. Don't try to copy deprecated objects over. All of the related fragments have "orderCol" somewhere in the name.

It took me about 10 minutes in total to do on my test environment.

Zephyr said...

Hey Paul, Thanks for the update. Will update the article with your comments. Thanks again for all the valuable inputs.

Divya said...

Javascript sorting works in C10 , but only when the prompts are saved before calling the report, or when they're passed in report URL, otherwise, it gives error: "script is null or not an object"

sanjay said...

Appreciation for nice Updates, I found something new and folks can get useful info about BEST COGNOS ONLINE TRAINING