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

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.

Find more posts tagged with

Accepted answers

All comments

Jörn Constabel

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

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