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

How to set pipeline substitution variable for Week Period combination

Received Response


Our PBCS application period holds data in a different way. I.e in Weeks format.

Eg: 01/05/2023



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:

Howdy, Stranger!

Log In

To view full details, sign in.


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