Skip to main content
Apr 30, 2020 8:57 AM UTC

Copying/Pasting from Excel to Grid View of a Dimension (Description)

Originally posted by Felipe Alcorta

Hi all:

In our current model, we have 100-200 new dimension members every month with actuals from our source system.  Part of the maintenance is the manual add of descriptions for all these base members.  I am doing it via a grid view in the dimension library but OS only allows me to copy paste (from Excel) one at a time.  Is there a way to copy/paste multiple at once using the grid view?  Or is there a better way?  I'm hoping I can leverage Excel + OS front end rather than having to find a solution via the Marketplace.

TIA

5 replies

Apr 30, 2020 9:10 AM UTC
Originally posted by Alona Edwards

I would suggest using metadata builder, it's the fastest way. It's an addin that allows you to copy/paste dimension names/descriptions and create xml code to upload back into OneStream.

Apr 30, 2020 9:31 AM UTC
Originally posted by Felipe Alcorta

Thank you but I did not see a metadata builder in the marketplace.  Do you have a link?

Apr 30, 2020 9:54 AM UTC
Originally posted by Alona Edwards

Its called Excel Metadata Builder 

Apr 30, 2020 2:59 PM UTC
Originally posted by Felipe Alcorta

Thanks, Alona.  I can't find that on the OS site.  where exactly is that located?

Apr 30, 2020 3:16 PM UTC
Originally posted by Alona Edwards

You need to login to Marketplace, it literally shows up on the front page:

https://xfmarketplace.com/OneStreamWeb/OneStreamXF.aspx

Or you can type the name in the search field and it comes up right away also