How to clear PCM multiple Periods for Forecast scenario with Groovy script
Summary:
I just want to clear all the data in PCM for Forecast dimension by using groovys script for all periods before laoding it from EPM.
I have tried groovy with mdw corss join but does not prodcue any result..
Has anyone achieved cleairng multiple periods with groovy in PCM?
Please advice..
my exmaple that doe snot work:
// Simple PCM clear for Forecast/FY26/Working across Apr..Mar
def cubeName = "PCM_CLC"
// MDX slice: all Accounts x Entity x Currency x PCM dims x business dims,
// restricted to Forecast, Working, FY26, and months Apr..Mar
String mdx =
"CrossJoin([Account].Members," +
Tagged:
0