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

Groovy to transfer data between cube

Summary:

I planned to transfer headcount data between cubes by using groovy.

Content (please ensure you mask any confidential information):

I have tried to use datagrid definition builder to transfer existing and new hire headcount from WFP to FS. I am trying not to do multiple datamaps for this.

I planned to transfer all Ilvl0descendants(existing employees) into OFS_headcount and i did map to filter the count. I tried to remove at index [3] (if i replace it as OWP_Existing Employees only) but headcount gets replaced instead for same combination of cost center and entity.

Currently, my script is as follows to roll up the headcount for same combination.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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