I wish the SAS optimizer in WRS would not tamper with SQL (submitted to a third-party database) that contains a count(distinct). Reading all the rows back to SAS and then doing the distinct count in SAS is so expensive in terms of I/O. Why can't it just send the SQL as-is? ... View more

Hi, Our users would really like to be able to derive new data items in WRS. Consider, a categorical item with 5,000 unique values. We can predefine several groupers in the Information Map but we will never cover all the possible combinations that users might want. If there was a CASE statement or some way of writing expressions, WRS would cover a lot more ground. One answer is to use EG rather than WRS but we're really keen on the web tool rather than the desktop tool. WRS is much easier to use for the bulk of our user community. Ian ... View more

Hi Everyone, We'd like a way to force the use of a particular predefined filter as soon as the user selects an item for reporting. For example, I am selecting an item called "age group" which always requires selection of one of 20 or so predefined age groupings. In other words, the background join from age to age grouping is dependent on the selection of one of the many possible groupings (i.e. part of the where clause). When the user selects "age group" we want to ensure that the prompted filter is used at report run time rather than assuming that the user will always turn the prompted filter on. We have about 50 maps where we'd like to use this functionality.Any thoughts? Ian p.s. We're still using 9.1 ... View more