Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi to all,
Anyone of you explain how to sort the month by order.
My month dimension like below
month:
Apr
Aug
Jul
Jun
Sep
Oct
Nov
Mar
May
Jan
Feb
But I want month list like
Month
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Nov
Dec
How about using Dual function in load statement. I got to learn that it can be used to maintain sort order for text field.
Example
Load dual ( NameDay,NumDay ) as DayOfWeek inline
[ NameDay,NumDay
Monday,0
Tuesday,1
Wednesday,2
Thursday,3
Friday,4
Saturday,5
Sunday,6 ];