Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Using substitution variables in source filters in DLR in data management

edited Dec 18, 2023 7:41AM in Planning 3 comments

Summary:


Content (please ensure you mask any confidential information):

Hi All,

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?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!