The SAS OLAP server cannot correctly sort dimension levels that contain date values with a Day format applied. For example, date values with a format of DAY2. would not be sorted correctly.

The following display shows a SAS^® Web Report Studio report built on a SAS OLAP cube where the Day Level has the DAY2. format applied. The report shows the following days for the fifth week of 2011:

January 31, February 1, February 2, February 3, February 4, February 5, February 6

Note: The order of the days is 1, 2, 3, 4, 5, 6, 31.

 

As a workaround, you can use a format that produces unique values across the Day Level. For example, you can apply the DATE7. format.

The following display shows the same cube but, in this case, the Day Level has the DATE7. format applied. The days of the week are now displayed in the correct date order:

January 31, February 1, February 2, February 3, February 4, February 5, February 6