If the source is an OLAP cube, the default view should be sorted based on the sort you defined for that dimension in your cube. You ahve the ability to define the sort order using five options:
1. Formatted Ascending
2. Formatted Descending
3. Unformatted Ascending
4. Unformatted Descending
5. Data set order
I would suggest setting the sort order for this dimension according to how you would like your default view in WRS to appear.
ya... but if you have a prompted filter, it will only save the sorting to the report you specified in your filter. An example: your prompted filter has two groups A and B. If you choose group A in your prompt and save the sorting. The report is viewed sorted for group A. But if you opdate your report by selecting group B in your prompt, the report for group B is not sorted.
I just tested this with WRS4.3 and the sort is remembered and honored even when selecting different values for prompts or anytime the report is opened. It is a requirement to save the report with the sort applied, as this saves the sort in the report definition.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.