If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

charts in 8.4 getting sorted automatically

Started by Ann, 28 Apr 2011 05:36:13 AM

Previous topic - Next topic

Ann

I am facing an issue in cognos 8.4 charts. I have a report which was recently upgraded from 8.2 to 8.4
in 8.4, the chart displayed in the report automatically gets sorted in alphabetical order on the material code value that is been displayed in x axis.
None of the data item, material code or the measure has been given an option to get sorted on the material code.

But in 8.2 the charts were not sorted.
Now my users want the output to look exactly similar to 8.2 output.

Can some one help me in solving this Issue.

PRIT AMRIT

Well, can you check in the data base table and see if [material code] is been defined as a Clustered Index. If yes, can you change it to Non-Clustered Index and see if it helps?

bvk.cognoise

material code property to  Non-Clustered Index  insted of Clustered Index.u can resolve it.
Regards
BVK

Ann