How to set pipeline substitution variable for Week Period combination
Our PBCS application period holds data in a different way. I.e in Weeks format.
We have started integrated EPM with Snowflake Database for Tableau Reporting. All the setup is done and able to export data using '01/12/2023' period. Data Export validated using Data Management as well using Pipeline Export (Hardcoded entries in startperiod and endperiod).
Now question is, we wanted to automate process using "EPM Job Scheduler" using substitution variables. From what I understand from different connect queries, variables need to be defined in "&PipeMth#&PipeYr" format.
I tried following.
Data Management Period Name and Target Year: