AnsweredAssumed Answered

Data Warehouse Calendar Period Format

Question asked by Dale_Stockman Champion on Feb 1, 2016
Latest reply on Feb 29, 2016 by Dale_Stockman

New to Jaspersoft - training class pending.

 

In the meantime, in ad-hoc views, pulling in calendar periods (Quarterly) and noticed that they are presented in QQ-YYYY format.  Also, noticed that when sorting on quarter, they are sorted alphanumerically, not by time/date.  So, when I sort, ascending and expect:

 

2015-Q4

2016-Q1

2016-Q2

2016-Q3

2016-Q4

2017-Q1

 

Instead, I get

 

Q1-2016

Q1-2017

Q2-2016

Q3-2016

Q4-2015

Q4-2016

 

Expect the underlying quarter data stored in the datamart is text - not date and that it needs to be changed from QQ-YYYY to YYYY-QQ in order to sort properly.

 

Any suggestions?  Or, is sorting "calendar data as if it were calendar data instead of text" an Idea that needs submission?

Outcomes