topic OLAP Cube is incorrectly sorting date values in SAS Web Report Studio

OLAP Cube is incorrectly sorting date values

BAdams — Thu, 01 Mar 2012 19:53:18 GMT

I used the built in SAS time dimension to define a date field. Looking at the results in WRS you can see that the quarters are not sorted in the correct order, nor are the months within the first quarter. Has anyone seen this before and more importantly, how can I correct it? Thanks. Below is how the data is showing up in WRS.

OLAP Cube is incorrectly sorting date values

Tobin_Scroggins — Mon, 05 Mar 2012 17:38:28 GMT

I have had this issue with using quarters. Don't have an answer for you but am hoping that someone does.

Re: OLAP Cube is incorrectly sorting date values

GCCarno — Wed, 17 Feb 2016 18:33:35 GMT

I am having a similar issue. Try following this guide, if you are successful, let me know.

http://support.sas.com/kb/19/651.html

Re: OLAP Cube is incorrectly sorting date values

muralavenu_gmail_com — Thu, 03 Mar 2016 00:36:08 GMT

Hi There,

This is very easy and you need to Edit the Cube. Before editing the Cube you should close the WRS Report, if you select this Cube as a source in this report.

1. Right Click on the Cube - Select Edit Structuture - Click on Next - Click on Next - Select the Dimension - Click on Modify - Click on Next - Select the Level(Variable) - Click on Sort Order - Select Dataset Order - Click on Next - Click on Finish - Click on Finish.

NOTE: In your screen shot, 2nd and 3rd Levels\Variables are not in Sort Order. So you need to Select Dataset Order for BOTH Variables. Now Try to open the saved report in WRS and check.

For Detailed information, find the attached .zip - VIDEO & Screen Shot for your reference.

Thanks & Regards,

Venu Murala | Sr. SAS Consultant.

Re: OLAP Cube is incorrectly sorting date values

ashu464810 — Wed, 29 Mar 2017 12:49:45 GMT

@muralavenu_gmail_com I tried the approach you mentioned but the date is not gettting sorted.

Your views are welcome.