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

Period to mmm date and sort

Started by Craigwjohnston, 28 Jul 2018 02:00:46 PM

Previous topic - Next topic

Craigwjohnston

Hi,

First time on the community so be gentle esp if this question has been answered elsewhere!

I have a report which pulls in months in the form integers 1 to 12. I want to keep them sorted as 1 to 12 but display each period on the report as Jan, Feb, Mar etc preferably without having to display each month as a text string. Originally I used a case statement to convert the periods into strings in the mmm format but that messed with my ability to sort them in the correctly.

Can someone please help me determine the native SQL I should use to achieve the above before I tear my hair out/opt for strong drink?

Thx!

sdf

#1
Hi,

Are you pulling your data from a relational or multidimensional source (cube)?
There may be different approaches depending on your source.

Also are you using the months in a list/crosstab or charts?

If it's a list or crosstab, there's a work around to drag both numeric (1..12) and Name (jan..dec) into your crosstab, sort by the numeric and set property to hidden.

You can also check advance sorting option for your data item.

Just my thought..