SAP Knowledge Base Article - Public

2646583 - Queries unable to run online - why is this even possible?

Symptom

Why do the reporting tools allow the creation of report queries that the system is unable to run online?

Environment

 SAP SuccessFactors - all reporting

Cause

The nature of the employee data being reported is that the potential amount of data in a given report - and processing required for said data - has no upper limit.  We do not cap query sizes (more detail below), and it is not appropriate to guarantee unlimited online processing within a set time, so there will necessarily be a threshold of combined data volume and complexity beyond which a query cannot reliably be run online by any web-based system.

We cannot simply prevent too-large queries from being created because predictive "run-time analysis" of algorithms is a largely theoretical field of computer science.  The system does not know how long a query will take to run until it tries.

Resolution

We prevent this eventuality from being a roadblock by offering the options to run such queries offline, with either the Run Offline or Download (CSV) options. This gives them the time and "space" they need to complete.

Performance of online queries, and therefore the scope of queries that can be run online, will increase in the long term with hardware and software upgrades.  In the short term, for non-viable queries to be run online they themselves must change, for example by being simplified, sub-divided or truncated.  We apologise for the inconvenience.

Keywords

KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

SAP SuccessFactors HCM Core 1711