Hi Angela,
I tried approach of creating SAS data sets and using it as input to prompts. I am not successful. Here is summary of what I did.
1. Create SAS Dataset with list of values for huge filter.
2. Register the SAS Dataset as table in library. The library is assigned to sas application of WRS. The table is given read metadata permission.
3. Create prompt in Information map with "Method of polulating prompt" selected as "User selects values from a dynamic list", Under DataSource options specify "Specify a data source" and point to table registered through management console.
When I tried to use this filter in WRS, I get error message as below in WRS logs:
2011-03-03 16:54:18,188 [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] WARN [ad13c8161727db9e:-74c6b0bf:12e749b56e6:4126sasdemo] com.sas.prompts.valueprovider.dynamic.workspace.PromptColumnValueProvider - Cannot resolve data type
2011-03-03 16:54:44,289 [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR [] com.sas.prompts.valueprovider.dynamic.DataProviderUtil - Unable to find physical table
com.sas.storage.exception.ServerConnectionException: Unable to find physical table.
Am I doing any wrong here?
-Nithin