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

omaltby's avatar
omaltby
New Contributor II
4 years ago

Copying data from Two Entities into One

Hello,

Apologies if this seems like a rather basic question but I couldn't see anything in the Golfstream app.

Is there a standard business rule I can take which copies data from one POV into another and modify it so I can effectively combining two base entities into one? 

Thanks,

Oliver

Finance

4 Replies

  • Mustafa_A's avatar
    Mustafa_A
    Contributor II
    4 years ago

    Hi omaltby 

    We have a data management step that copies data from one entity to another.  You can create a "Copy Data" step - similar to this below. You can adjust your source/target scenario, time, view etc. accordingly. 

    I haven't tried copying from two entities into one. But I believe you will need to add both the source entities in "Source Entity Filter"  and your target entity in "Destination Entity"

     

    Hope this helps.

     

    Best,

     

    Mustafa A

     

     

     

     

  • omaltby's avatar
    omaltby
    New Contributor II
    4 years ago

    Hi Mustafa_A 

    Thanks for your reply.

    I tried following your suggestion but receive an error message when I set two source entities with one target (see below). As soon as I change it to one source entity to one target the copy is successful.

    Thanks,

    Oliver

    • Mustafa_A's avatar
      Mustafa_A
      Contributor II
      4 years ago

      Yep! I haven't tried it with two entitles before. I don't know if it'll work doing one entity at a time.

      I believe you can write a Seeding Rule in Finance BR to copy multiple entities. 

  • ckattookaran's avatar
    ckattookaran
    Valued Contributor
    4 years ago

    I'm not sure you can do this using copy data. Either you'll have to create a custom rule that does an accumulation or extract the data and use mapping and load it back. There could be another way, but I can't think of anything else.