System Info Dates

From DataSelf Knowledge Base
Jump to navigation Jump to search

Notes


System Info

The System Info hierarchy in the DSA OOTB data sources provides the following dates from the _C_DataRefreshedAsOf SQL view:

  • the last refresh datetime for the underlying SQL data warehouse data ("DataRefreshedAsOf"). When the DataRefreshedAsOf field is dropped in the Details box, it will appear in the pop-up information in DSA views when the mouse hovers over a mark (a measure), then becomes available to be added to the title of a DSA view.
  • the following relative dates, These dates are relative to the DataRefreshedAsOf date, and are recalculated at every SQL data warehouse refresh. They are used for comparison filters or calculated fields, to compare with another date field.

ThisDateTime AS DataRefreshedAsOf,

TodayFiscalCode,

YesterdayDate AS Yesterday,

YesterdayFiscalCode,