Timeliness Check with parameters not working (v 15.4 on prem)

Question

Hello, Ataccama Community. I am hoping you can help me figure this out. I am trying to create a timeliness check. The objective would be to have a general DQ rule that accepts an update date and then allows the user to configure a minimum delay and a maximum delay.

The rule would find the number of days from today and the update date, then take the maximum of that value. If the max of that delay is mroe than the maximum parameter set, then it should return a “MAJOR DELAY” indication.

Here is my challenge. It does not seem to work when I use the parameter. It only works when I use a hard coded value for the “maximum delay” in the test.

I am hoping someone can help me figure it out.

BrianF · Answer

Hi,Have you tried this with the condition as Delay Value > 3, as opposed to Delay Max > 3?Also, I would suggest ensuring that the date formats are correct.Note that today() returns current date, not current datetime. The function now() providesdatetime.I would also ensure this by adding a condition before MAJOR_DELAY, which captures anything not in the right format, and/or nulls.Hope that helps!Brian

Sign up

Login to the Ataccama Community

Scanning file for viruses.

This file cannot be downloaded