Not all pages of the available values are showing when trying to apply a runtime filter.
- SAP SuccessFactors Workforce Analytics
- Adhoc Reporting
Reproducing the Issue
When trying to apply a runtime filter at the report, not all pages availables are shown at it, only if when clicking into the 'Last' button. The 'Search' option to find the field will only work if you reach the page that the desired information is.
The pagination framework works with the values being fetched in batches, so once the user has reached last page in current batch, then a call will be triggered to fetch the values for next batch, and so on, until the max page number would be populated accordingly.
The main reason for this is to avoid serious performance issues, hence this is now an expected behavior.
Ad Hoc Filter Not All Pages Search Missing Values , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem