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

Summary:

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

Eg: 01/05/2023

01/12/2023

11/02/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.

Register

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