Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS UpFront => Topic started by: Arivu on 27 Jul 2007 07:21:40 AM

Title: Date dimension not in chronological order
Post by: Arivu on 27 Jul 2007 07:21:40 AM
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
Title: Re: Date dimension not in chronological order
Post by: MFGF on 30 Jul 2007 03:49:07 AM
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.
Text only | Text with Images