Change Period/Scenario/Year in PCMCS Query
Need help on automatically changing the Period/Scenario/Year in PCMCS Query.
We have a script to calculate markup which runs a query on PCMCS, but every time we want to run the mark-up script, we have to manually update the year, period and query in the query. We want to change the period, year and scenario automatically in PCMCS query through a script.
Is it possible to do it using EPM automate or any other method?
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):