AsOfDate

Download sample file: as_of_date.csv

Atoti Limits uses the as_of_date.csv as the application’s AsOfDate. It assumes there is one AsOfDate. Every start of the business date, the module expects the clients to send in the as_of_date.csv with the new date to roll over the AsOfDate.

Atoti Limits uses the AsOfDate during the evaluation against the business cubes. It first queries the valid limits, where StartDate <= AsOfDate <= EndDate, then composes the MDX queries with the AsOfDate against the business cubes.