Move Element to Another Hierarchy (TI)

[macklovesraine11]

Hi Guys,

Good day to you all.

I'd like to know if it is possible for TI to move elements between consolidation hierarchies? If possible, what would be the best suitable function for it? Here's a scenario: In the "People" dimension, the following structure exists.

- All People
- Directors
+ Directors - Current
+ Directors - Previous

Supposed we have "Michael Busita" as an employee under All People > Directors > Directors - Current. What I'd like to have is some active form (utility) to update employee (resign) from Directors - Current to Directors - Previous.

Thanks for the help!

Michael

[tomok]

DimensionElementComponentDelete, DimensionElementComponentAdd

[macklovesraine11]

DimensionElementComponentDelete, DimensionElementComponentAdd

Hi tomok,

But it will also delete employee's data right? For example if Michael Busita has already data for Annual Salary measure, it will be deleted if I use DimensionElementComponentDelete function.

[declanr]

DimensionElementComponentDelete, DimensionElementComponentAdd

Hi tomok,

But it will also delete employee's data right? For example if Michael Busita has already data for Annual Salary measure, it will be deleted if I use DimensionElementComponentDelete function.

Hi,

Data is held against an N-Level element only; the componentdelete function breaks the link between an element and its parent but the data will still be held against the element - it just may not be part of a hierarchy anymore.