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

Upper level member for calc script & IPM insight

in Planning 6 comments

Summary:

IPM insight selection cannot be dynamic parents.

Content (please ensure you mask any confidential information):

Dear experts,

I am trying to use the IPM insight function. The requirement is to run insight on Gen 10 Cost Center (11 generations in total) and all level 0 Entity members. I couldn't select the Gen10 cost center directly as it does not support running on dynamic members. Selecting level 0 members of total cost center is not plausible as we have more than 30,000 cost centers, which takes more than 1 day to process and still doesn't finish.

Long story short, I am trying to parse Gen10 data to alt store members, which is around 400 of them with the suffix of "_IPM". I know the Groovy way to make my life easier, but I would like to know how to do it using a calc-script too. I have written a calc-script which sometimes takes around 20 minutes to run, but sometimes it runs for only 1 minute. I will attach the script here so that everyone can help me.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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