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. ... View more

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. ... View more

For relational data, you can enable logging on the pooled workspace server that will capture the query generated. http://support.sas.com/kb/34567 For OLAP based reports, you can enable OLAP Server logging using http://support.sas.com/kb/36/728.html. ... View more

Please take a look at the following SAS Note and see if it is helpful: http://support.sas.com/kb/36953 ... View more

If your filters are to be based on the user or a group the user is assigned to, you may want to take a look at the following samples: http://support.sas.com/kb/37798 http://support.sas.com/kb/31563 ... View more

The "Setup Destination Report" button is only available when you link from a table or graph. It is not available using a text box. ... View more

Currently, SAS OLAP does not have the concept of shared members. However, SAS9.3, due out later this year, will introduce the concept of shared dimensions. Based on what you are describing, perhaps these shared dimensions would allow you to accomplish what you need. There will be a SAS Global Forum paper presented on this topic, so I would suggest taking a look at the proceedings once they are posted. http://support.sas.com/events/sasglobalforum/2011/index.html ... View more

There is no technical limit to the number of concurrent users for a particular WRS report. The only limitation would be the resources available in your envornment. You are correct in that each user will access memory while viewing a report, but memory consumption would vary depending on the content and complexity of each report. Two things you may want to consider: 1. You can use the WRS Key Actions log to monitor who accesses any particular report. Documentation for the Key Action log can be found at http://support.sas.com/documentation/cdl/en/biwaag/63149/HTML/default/viewer.htm#a003050065.htm. 2. You may also investigate the Audit and Performance Measurement tool. http://support.sas.com/rnd/emi/EbiApm92/index.html ... View more

In a particular report, you can select File>Properties. In the properties window, click on the Format tab. You can then select Use Customized Colors and select the colors you would like to use. ... View more

Nithin- Please be aware that using the dynamic generation of these values does require a query to be run against the data to populate the distinct values. If you are using large data, this may take a bit of time to return. This may be acceptable in your situation. If not, you may explore using an external table as Angela mentions and possibly build that table periodically as it makes sense with your data. ... View more

You may want to make sure that your Time dmension is set to a type of "Time" and not "Standard". This will ensure that all of the time functions are available to you. If this is set to standard, they will not be. ... View more

Please take a look at http://support.sas.com/kb/31336 and see if this helps. ... View more

You could create a new data item of type Date that is based on a case statement. For example, a case statement could looke like the following: case when <<table.date1>> ne . then <<table.date1>> else <<table.date2>> end ... View more

You may also want to check out http://support.sas.com/resources/papers/proceedings09/046-2009.pdf. ... View more

You can hide a dimension from a user or group of users by denying ReadMetadata permisisons for that dimension. However, if a calculated member or measure is based on this dimension, the user will have to have access to the underlying dimension to consume the calculated member/measure. ... View more