As-of Date Analysis or Point-in-time Analysis functionality can be achieved by passing a variable PARAM_EFFECTIVE_DATE from BI Answers to BI Server and eventually to the Composite view object API. The variable PARAM_EFFECTIVE_DATE holds the date as of which the analysis must be performed on Date-Effective Entities. BI Server interprets the parameter and passes specific hints to the Custom view object API to use the specified date instead of SYSDATE in the actual query. The query returned is similar to Current Date Analysis, with the only difference being that the date value passed through PARAM_EFFECTIVE_DATE is used instead of SYSDATE. This date value is applied for all Date Effective entities being queried, irrespective of it being a fact or a dimension.