Hi,
Is it possible to use a dynamic expression such as TRUNC(SYSDATE, 'IW') - (7*52) - 1 as a condition value for an information source entity criteria? Trying to add this for ITH_DATE_CREATED in FACT_INVENT_TRANS_HIST information source but i get below error when trying to click on save,
Invalid date (TRUNC(SYSDATE, 'IW') - (7*52) - 1) defined for item FACT_INVENT_TRANS_HIST.ITH_DATE_CREATED. The date format should be YYYY-MM-DD HH24:MI:SS
Page 1 / 1
Hi
https://docs.ifs.com/techdocs/25r1/050_reporting/020_data/010_information_sources/050_data_mart_access/040_handling_incremental_load/#criteria_definition_for_incremental_entities
In the “Column Name” field you can provide an expression, but that should be something returning a static value to be compared with the “Condition Value”. The value provided in the “Condition Value” field is validated against the “Data Type”. I think the error message is because you might have selected the data type as “date”.
Best regards,
Subash
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.