08-07-2014 07:00 PM
Unfortunately there isn't a way to have a dynamic data item control used in a report object. I raised this as a feature request in August 2013 with SAS Tech Support #77611064595. I envisage this may be very useful for people to use in reports where report objects roles can be dynamically assigned by the end user, similar to the variable selection list prompt type in SAS Enterprise Guide.
08-10-2014 05:44 AM
There is a way but it's not pretty. You have to load all the data in single column but use another field to indicate the record type. The first field can be used as an X axis and the record type can be set as a user selected filter. Its not ideal but it works.
08-25-2014 09:00 AM
This is a good requirement and we are planning for this kind of functionality in the future release. The idea is to empower business users with the ability to change the Measures, categories and filters, on a report object in a report, on-the-fly, without having to edit (re-author) the report. For example, end users can replace a measure or a category on a bar chart, from a list of variables and if satisfied, they can save this state of the report as a separate copy, without overwriting the original.