Focal Point
ACROSS value sequences lost in OLAP

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6001004081

August 15, 2006, 12:10 PM
jif26
ACROSS 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 ?


WF 7.6.4