Removing closed entities from the entity hierarchy without impacting historical data.
Summary:
We would like to remove the Entities from the respective hierarchy of the Entity Dimension from the period in which the entity got discontinued but the same entity should appear within the respective hierarchy of the Entity Dimension when we look at the periods prior to the close period of the Entity.
I.E:
If the Entity 1001 got discontinued in Sep-2024 then the respective hierarchy of the Entity Dimension till August-2024 should show the entity 1001 in the respective hierarchy of the Entity Dimension but from Sep-2024 and onwards, entity 1001 should not appear into the any hierarchy of the Entity Dimension.