August 15, 2006, 12:10 PM
jif26ACROSS value sequences lost in OLAP
I want to report volumes across months in an unusual order (going from november to october). When doing this below, it works no problem.
TABLE FILE MYTABLE
SUM VOLUME
BY KEY
ACROSS MONTH COLUMNS 'NOV' AND 'DEC' AND 'JAN' AND 'FEB' AND 'MAR' AND 'APR' AND 'MAY' AND 'JUN' AND 'JUL' AND 'AUG' AND 'SEP' AND 'OCT'
END
When using OLAP, the initial report works, but as soon as I do an "OLAP operation", the months revert back to alphabetical order. Is there a way for me to tell OLAP to retain the sequence I hardcoded below ?