how can I change the codes of an entity without ruining the relationship?

Noura BOURRAH
Noura BOURRAH Active Partner
Second Anniversary First Comment
in Platform

Hello dear community, 

I have two entities "account" and "CF" where "CF" is parent of "account".

what I need to do is to empty the entity "CF" and reload it with a cvs file where the codes of the entity have changed.

I also have another csv file (account code; CF code; CF description) I use for the mapping of the relationship account-----> CF  but this one has the old codes for "CF".

how can I change the codes of "CF" with Board without ruining the relationship.

Thanks in advance.

Answers

  • Jörn Constabel
    Jörn Constabel Customer
    Fourth Anniversary 10 Comments Advocate 5 Up Votes

    Hi noura bourrah,

     

    I think the only way is to change the CF-code in your csv file for the mapping, clear the old entities in BOARD and load the entities from the corrected csv file. 

     

    You can also extract the current entitiy tree into a csv-file, change the code, clear the old entities in BOARD and load the entities again from tree csv-file.

     

    But please keep in mind that to clear the entities means also, that BOARD will clear related cubes. 

     

    Regards,

    Jörn

  • Ravichandra Aj
    Ravichandra Aj Active Partner
    10 Comments Second Anniversary Photogenic

    noura bourrah 

    in addition to above mentioned comments 

     

    follow this best practice :

    1. Extract entity

    2. Clear the entity (take backup of the cubes associated with the enity)

    3. rename codes or resize your entity 

    4. Reload entity.

     

    it will not ruin your relation schema

     

    I hope it helps you.

     

     

    Thanks,

    Ravi

Categories