SAP Knowledge Base Article - Public

2505916 - Excel Refresh Query not Working as Expected

Symptom

You created an Advanced Filter query in a workcenter view however when you refreshed the data in Excel Add-in you have different data from that filter.

Reproducing the Issue

Example using Accounts View in SAP Hybris Cloud for Customer

  1. Go to Customers Workcenter
  2. Go to  Accounts View
  3. Select filter All Accounts
  4. Go to Advanced Filter and filter the data as you like
  5. Click in Export
  6. Open in Excel
  7. Modify the data (for example delete rows)
  8. Click in Refresh
  9. Excel has more data than your initial download

 

Cause

Excel Add-in respects the data from the query as for example All Accounts, once you hit Refresh it will ignore the Advanced Filter and will download the All Accounts query again.

Resolution

This is the expected system behavior.

Keywords

KBA , SRD-CC-FED , Feeds , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer all versions