If you are unable to create a new account, please email support@bspsoftware.com

 

Prompted filters not working in CWA when field has prompt info references set in

Started by ehiggins1505, 08 Nov 2017 12:39:30 PM

Previous topic - Next topic

ehiggins1505

We are having an issue in CWA where reports that have a prompted filter created are returning no data when that particular field in FM has the use/display/filter item references set in FM to filter and use codes but display the name. This works fine in report studio and query studio. We opened a PMR and were informed this functionality does not exist for CWA and that we should remove these references in FM. When we did this, our query studio reports began returning no data for existing reports that contain filters on these field that previously had these references. Scheduled verisons of these reports work just fine for some reason. We backed out the changes, but are left with the original issue that we cannot use a prompted filter in CWA on the fields that have these references set. IBM says its a known issue and referenced https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=65349 but I'm hoping there is some workaround so that both query studio and cwa can run against the same model using prompted filters. Seems odd this functionality was left out of CWA. Thank you!