Using substitution variables in source filters in DLR in data management
Content (please ensure you mask any confidential information):
We are extracting forecast data from our planning application on a daily basis and sending to data warehouse for further analysis. To extract data, we are using the "export to a file" feature in DM. We have a requirement to define the source filters in Data load rule as substitution variables and automate passing values on a monthly/daily basis. For ex: scenario should be automatically updated for the current month as "Dec_Forecast 2023" in the source filters. It shouldn't be updated manually as customer wants to minimize the manual work of updating source filter parameters. Is this possible in the current context of DM/data integration? if not, Is there any workaround to achieve the same?