Forum Discussion

fc's avatar
fc
Contributor
2 years ago
Solved

OS metadata

Hi everyone, I have a question related to the upload of a new dimension hierarchy through an XML file. I currently have a file excel with the whole hierarchy for each dimension that I keep updati...
Metadata
  • drgerrow's avatar
    drgerrow
    2 years ago

    fc You can setup the xml's Relationships section to "Delete" a Relationship like this:

    <relationships>

      <relationship parent="{parent name}" child="{child name}" action="Delete" />

    </relationships>

     

    Note that deleting the Relationships may result in Orphaning a member, which in your case is what you want.  A member that is Orphaned does not lose/delete its data, so as long as you upload your new file and re-create the new Relationships, your overall data will be unaffected.

sudarshan's avatar
sudarshan
New Contributor III
2 years ago

Hi,

We have a similar use case where we require the hierarchy of a UD to be replaced and not merged. We go with the approach of "Break and Build" using xml to completely replace the existing hierarchy with the new one.

First create a break xml for the metadata by choosing the dimension and removing all relationships so everything gets orphaned and then for the build xml you just need to take an xml extract of the new hierarchy for all the members. Then the hierarchy is built again from scratch, thus replacing with the new structure. Though you do need to careful, as if they are any missed members they would remain orphaned. 

Thanks,

Sudarshan