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 limit definitions, where StartDate <= AsOfDate <= EndDate, then composes the MDX queries with the AsOfDate against the business cubes.

Column Name Description Required Value Example
AsOfDate AsOfDate Y 2020-01-01