The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Copy account to other account on IC entity
Hello,
I'm looking for a member formula, or business rule to copy data from an entity to the IC entity, where also another UD member is substituted.
Example of source data:
Cb#100:E#3100:P#?:C#...
Hi BenvanBergen,
Another option you could consider which could be easier to set up and best from a performance point of view would be to use Data Management Export Sequences - especially if this is going to apply across most of your entities / ICs.
Have a look at this Tech Talk that explains how to configure a DMES. This subject is covered from minute 20 onwards:
This will also allow you to easily flip or map your UD2 and UD3 at the same time.
Hope this helps.
Thanks a lot Henning!
I'm aware of the Data Unit concept, but not always clear on the implications, good that you mention it.
My main question here is how to write 2 loops that are nested. 1 would be to loop through the 7 IC members, the other to loop through the UD3 (40 members). So that I can specify , the different destination and source members.
A BR is probably better, I can include it in a seeding step, because the input is in another scenario.
I appreciate your valuable input, thanks again!
Henning
OneStream Employee
OneStream EmployeeHi, sounds like a data buffer will suit this best.
E.g. use ...
api.Data.GetDataBufferUsingFormula("RemoveZeros(myMemberFilter(s)")...loop through the cells of the data buffer and for each IC member and UD3 member, you change the member to your destination member and push the call to your destination data buffer which you post to the cube in the end.