Date dimension not in chronological order

[Arivu]

Hi am Arivu new to cognos, I have an issue in poweplay web reports.

Year dimension is not in chronological order in one of the poweplay web report.  it's like 2007, 2005, 2003, 2004  in stead of 2003, 2004, 2005, 2006, 2007

Thnx in advance
Arivu

[MFGF]

Hi,

This is probably a result of the way the Time Dimension has been modelled in the cube.  If this is the case, you need to get the cube designer to fix this using Transformer, then re-build the cube for you.  Alternatively you will need to sort the years every time you use them in PowerPlay Web - which is not ideal.  Or are you saying it's just for one single report?  If so, then fix the report and re-save it.

Regards,

MF.