Time Series Functions

BI EE has the time series functions Ago() and ToDate(). Have you ever wondered how these work? The best way to find out is to examine the SQL that is generated when a query includes these functions. The structure of the SQL is determined by the database features supported by the target database. This presentation displays what happens in the case of Oracle 10gR2 (and 11g), which are "best case" databases for these functions: How Time Series Functions Work.