How to add a prefix to an entity code 

unknown

Hello,

We need to prepare a new structure for a hierarchy and one idea was to tadd a prefix to the historical value. If we do it by extracting, modifiying outside of BOARD  and reload the entity, the internal code will be different in we will loose the coherence in the DB. The best way would be to modify the code directly in BOARD but with more than 1000 elements is kind of cubersome.

Is there a way to modifiy the code of an entity by procedure? or do you have some good advise?

Thank you and best regards

Marcel

Helmut Heimann

Hi Marcel Bila,

 

it's best practice, not to change entity members directly in BOARD's DB, you should only change descriptions--anything else would lead to the difficulties you also address. BTW: how do you think to maintain the relationship of your entities to the cube data? If you just change the codes of your entity members, you'd lose the connection to the transactional data.

That said, the best way to achieve your aim would be to extract the entity members, change and reload them and keep in mind to change the entity members in your fact data appropriately. The internal code will remain the same if you change the sorting option to "none" prior to extracting and reloading.

You could use a procedure to extract the entity (clear afterward) and reload it with different codes using ETL.

After that, you can reload your corresponding cube data using a similar ETL for the codes.

 

HTH

Helmut