EPM Integrator Agent - PBCS integration with EBS
Hello,
We are using the EPM integrator agent to extract data from EBS DB. We have a query where we hard coded the period (...AND gb.PERIOD_NAME = 'NOV-20'...).
I would like it to not be hardcoded, I saw that we can use variable binds however we will have to choose the period and select the period in the bottom of the Data Load Rule page. Therefore,we will have to select twice the period. Is there a way to make a script that will read the period that the user selected in CDM and update the query or update the variable^