Symptom
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.
Environment
SuccessFactors Analytics - Detailed Reporting
Cause
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.
Resolution
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.
Keywords
KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Problem