Forum Discussion

ChoolweJoe's avatar
ChoolweJoe
New Contributor
3 months ago
Solved

Entity - In Use Feature

Hi all, We have a situation where an Entity was created and incorrectly set up and contains data for period 2024M12 and 2025M3. We decided to create a new Entity and updated the transformation ...
Application Properties
Metadata
  • rhankey's avatar
    rhankey
    2 months ago

    I would presume in the two months since the question was asked that you might have conducted a couple tests in a sandbox to discover the answers to your questions.  However, if this still remains an unknown:

    • Setting InUse=False will prevent new data from being imported.  This property is ScenarioType/Time varying, so can allow you to load or reload data up to a certain point, and prevent doing so thereafter.
    • Setting PercentConsolidation=0 for the Parent/Child relationship will stop the entity from consolidating (aggregating) to the parent entity.  This property is ScenarioType/Time varying as well, so you can have it consolidate to one parent up to a certain point in time, and not thereafter.  If the entity where to have moved, you could assign the same entity to a second parent, to which you would set PercentConsolidation=100% after a certain time period.  When combined with some custom member lists, PercentConsolidation opens the door into time varying Entity hierarchies - where the hierarchy users see in reports will vary based on what ScenarioType/Time period they run the report for.

     

chul's avatar
chul
Contributor III
2 months ago

If it's an entity that contains data but you don't want it to consolidate nor allow users to mistakenly load data to it, you can change the In Use to False. What type of impacts are of concern?

ChoolweJoe's avatar
ChoolweJoe
New Contributor
2 months ago

Hi Chul,

Thanks for the feedback.

My concern was if the data that still exists, preserve it for Historical reload but date stamp the In Use to avoid data being loaded to the Entity in the future.

  • rhankey's avatar
    rhankey
    Contributor II
    2 months ago

    I would presume in the two months since the question was asked that you might have conducted a couple tests in a sandbox to discover the answers to your questions.  However, if this still remains an unknown:

    • Setting InUse=False will prevent new data from being imported.  This property is ScenarioType/Time varying, so can allow you to load or reload data up to a certain point, and prevent doing so thereafter.
    • Setting PercentConsolidation=0 for the Parent/Child relationship will stop the entity from consolidating (aggregating) to the parent entity.  This property is ScenarioType/Time varying as well, so you can have it consolidate to one parent up to a certain point in time, and not thereafter.  If the entity where to have moved, you could assign the same entity to a second parent, to which you would set PercentConsolidation=100% after a certain time period.  When combined with some custom member lists, PercentConsolidation opens the door into time varying Entity hierarchies - where the hierarchy users see in reports will vary based on what ScenarioType/Time period they run the report for.