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 clear PCM multiple Periods for Forecast scenario with Groovy script

edited 4:31AM in Planning

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," +

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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