SAP Knowledge Base Article - Public

2222911 - Detailed Reporting query shows out-of-date information for employees


A Detailed Reporting query shows data (e.g. an employee's manager) which is no longer current, despite the date being set to "Current Date" or an equivalent.


SuccessFactors Analytics - Detailed Reporting


Each table used by a Detailed Reporting query (which contains a date field) has its own setting in Date Options.  The general setting for the query focuses on the Driving Table (highlighted in green in the schema diagram) with a single other option applied to all other tables.  If this other option is not "Current Date" some of the tables may not be showing only the most recent information, or any information at all if the data only starts at a certain date.


Ensure that the driving table, the table containing the field in question, and every table connecting the two in the schema diagram, are set either to Current Date or another option that includes the current date (e.g. the dynamic value "Current Year").  If the general date options for non-driving tables should be set to something else, you can use the Overrides tab in Date Options to configure individual tables.


KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Problem


SAP SuccessFactors Workforce Analytics all versions