SAP Knowledge Base Article - Public

1739600 - Predefined filters in QAAWs are completely ignored in Dashboard Design 4.0

Symptom

  • Predefined filters (at universe level) in QAAWs are completely ignored in Dashboard Design.
  • Same issue using BI web services as well.
  • This feature used to work in XI3.x

Environment

  • SAP BusinessObjects BI4.0

Reproducing the Issue

  1. Launch Qaaws
  2. Select Year, State and Sales Revenue and select predefined filter 'Last Year' from the eFashion Universe
  3. In the Qaaws Preview, the results appear correctly
  4. Click Publish
  5. Click on 'Copy to Clipboard'
  6. Open Dashboard Design, Data Manager -> Web Service (QAAWS) and paste the QAAWS URL in WSDL URL click import
  7. Match the Row folder to 3 columns and 10 rows
  8. On 'Usage Tab', check 'Refresh before Components are loaded'
  9. Select a Spreadsheet Table, map the same columns and rows as used in the web services
  10. Preview

Cause

  • Issue is currently under investigation under # ADAPT01650253
  • See also #ADAPT01647272

Resolution

This issue has been fixed in the following releases:

  • BI4.0 SP4 Patch 4.2
  • BI4.0 SP2 Patch 2.20
  • BI4.0 SP5

Keywords

filters Pre defined filters BI4.0 SP4 FP3 SP2 Qaaws query as a web service BI web services ADAPT01650253 1650253 working , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Bug Filed

Product

SAP BusinessObjects Dashboards 4.0