| Column Name | Description | Required | Value Example |
|---|---|---|---|
| AsOfDate | AsOfDate | Y | 2020-01-01 |
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.