We run scheduled data validation for OOTB ERP metrics. We have to hard-code future fiscal periods however this has drawbacks:
- Putting in more fiscal periods than actually needed which slows run time or could cause a time-out
- Requires ongoing parameter maintenance by FDI admin
Benefits to dynamic parameters
1. Reduces data validation effort
2. Reduces scheduled data validation parameter maintenance
3. Reduces run time of scheduled data validation to ensure it completes close to pipeline refresh time
4. Helps reduce query timeouts
5. Supports FDI governances processes which require periodic data validation but for which repeating previously completed data validation is problematic Example:
current fiscal period parameter: June-December 2026. In June this runs and June data is validated. Evidence saved for internal audit. In July this runs and now June AND July are validated. The repeat validation of June is un-necessary and requires prior evidence to become null and void).
dynamic fiscal period parameter: Current fiscal period. In June this runs for June. In July this runs for July.
Ideally dynamic parameters support:
T = Today
M = Current Month
Y = Current Year
Then users can use +/- syntax such as T+30 (today plus next 30 days or M-3 (prior 3 months)
Please evaluate other dynamic parameters that would be suitable based on subject area.
