cancel
Showing results for 
Search instead for 
Did you mean: 

Sorting Load Date based on the most recent date

Former Member
0 Kudos

All,

To cater to a very specific requirement, we are loading the date values into an Info Object (Headcount Load Date) which is of type "Characteristic" and not "DATS".

This Object essentially gets loaded with the system date in the format DD.MON.YYYY (20.MAY.2009) on a weekly basis.

When a variable is created for this Object, we have the drop downs being listed like below in a random order:

10.JAN.2009

14.MAR.2009

01.NOV.2008

07.MAR.2009

13.DEC.2008

17.MAY.2009

22.SEP.2008

Now, the requirement from the User is that these Date values should be appearing based on the most recent load date instead of them having to scroll down to pick the most recent load date. As shown below:

17.MAY.2009

14.MAR.2009

07.MAR.2009

10.JAN.2009

13.DEC.2008

01.NOV.2008

22.SEP.2008

Would the above sequence be possible to achieve? When we use the ascending or the descending option in the Drop downs, it's only sorting based on the number and not on the months. The option of ascending or descending in the drill down therefore does cater to the requirement.

Do you guys have any idea?

Regards,

Manick

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Manick,

If you are allowed to use APD (Analysis Process Designer), then you could achieve this by using the option Sort Data as the transformation connector.

Hope it helps.

Regards,

Group BI