Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor II
6 years ago

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

Metadata

5 Replies

Sort By
  • OSAdmin's avatar
    OSAdmin
    Valued Contributor II
    6 years ago
    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.

  • OSAdmin's avatar
    OSAdmin
    Valued Contributor II
    6 years ago
    Originally posted by Felipe Alcorta

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

  • OSAdmin's avatar
    OSAdmin
    Valued Contributor II
    6 years ago
    Originally posted by Alona Edwards

    Its called Excel Metadata Builder 

  • OSAdmin's avatar
    OSAdmin
    Valued Contributor II
    6 years ago
    Originally posted by Felipe Alcorta

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