AsOfDate

Download sample file: as_of_date.csv

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

The Limits module 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