Using Substitution Variables in Pipelines for Metadata Loads
Data Exchange Pipelines have now replaced the batch functionality previously available in Data Management, allowing administrators to have a more enhanced visual representation of scheduled jobs. Pipelines consist of a series of stages, which are made up of a range of jobs, including business rules, integrations or platform jobs such as database refreshes. Substitution Variable Setup In a previous blog post, I explained how substitution variables can be used in pipelines using format &DataLoad_Mnth#&DataLoad_Year where the variables are in the below format: DataLoad_Mnth – references the current month for loading actuals (e.g. Mar) DataLoad_Year – references the current financial year for loading actuals (e.g. FY26) See my previous blog here for more detail: https://lydia-maksoud-epm.blogspot.com/2024/01/Substitution-Variables-Pipelines.html This works great for data load integration jobs; however, I’ve recently found that this method does not work when attempting to...