March 03, 2005, 03:56 PM
<Lance>MS OLAP Display
I have a MS OLAP Dimension that is year, quarter, month. In MS OLAP is is sorted by the key which for month is the numeric value, but displayed as an alpha field, (e.g., 3 is the value sorted, March is displayed). In WebFocus it is an alpha field and sorts alpha (E.G, February, January, March for Quarter 1 is displayed). Can this be changed in the metadata?