Versioned Hierarchy Management in Dynamic Planning
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Versioned Hierarchy Management in Dynamic Planning

  • Dark
    Light
  • PDF

Article summary

The Enable Versioned Hierarchy Management flag is used to automate the dimension hierarchy process for the Analytical Model and Master Model. You can enable this flag to automate the actions such as:

  • Locking the model
  • Clearing the rollup data 
  • Saving the hierarchy updates
  • Unlocking the model
  • Running aggregation calculation

When this feature is enabled and you save and publish the hierarchy, the application automatically performs these actions. 

Note:
To maintain multiple hierarchy versions, please contact Planful Support to request the Enable Versioned Hierarchy Management flag be set to Yes.

How to Update the Published Hierarchy for End Users?

  1. In SpotlightXL, go to Model Setup.
  2. Select the calculation from the Restore Rollup Data Calculation drop-down list. This will restore the rollup data after the changes to the hierarchy.

  3. On the Model > Dimension page, set Update as the Action property value to make any changes in dimension members from the published hierarchy.

  4. On the Dimension page, click Save. This will save and publish the updates.

  5. The selected calculation in Restore Rollup Data will run automatically.

How to Add and Publish a New Hierarchy Version?

  1. In SpotlightXL, navigate to Model > Dimension and select the desired model.

  2. Select the desired dimension. 
  3. Select New Hierarchy Version from the hierarchy drop-down list, and update the name.

  4. In the Action drop-down list, select Update.
  5. Make the necessary hierarchy changes and click Save.
  6. Navigate to Model > Setup to map the updated dimension hierarchy version.

  7. Click Publish Hierarchies. Users will be notified upon completion.

Notes:
  • If you don't wish to update the existing published hierarchy, you can create up to 10 versions of each dimension hierarchy.
  • To create other versions, you must first generate a base hierarchy model/main hierarchy model.
  • These dimension versions can either have the same or different dimension structures in the model. You can then update the new version of the published hierarchy and publish it.
  • You can select Update, Set Display Label, or Set Dimension Based Properties to update the existing hierarchy.
  • Select Append to add leaf-level members to any level without affecting roll-up data, whether root or roll-up members. It is accessible when the model is generated and locked.

How to Publish a Hierarchy?

  1. In SpotlightXL, navigate to Model > Setup.
  2. Select the desired hierarchy and calculation.

  3. Click the Publish Hierarchies option in the Actions column. The selected version will be published.

  4. Optionally, select appropriate versions for each dimension and calculation and click Publish Hierarchies to publish the selected versions to the end users.
Notes:
  • After publishing the new hierarchy, only the data common to old and new hierarchy members are retained.
  • Versioned hierarchy is also supported for export/import models
  • Adding dimension members from web/append API adds them to the existing published hierarchy.
  • If you already have 10 published hierarchy versions, delete any one of the hierarchies to create a new one.

How to Delete an Existing Published Hierarchy?

  1. In SpotlightXL, navigate to Model > Setup.
  2. Select the desired hierarchy. 
  3. Click the Delete Hierarchies option in the Actions column. The selected version will be deleted.

Notes:
  • The first published hierarchy is the main hierarchy, and you cannot delete a version hierarchy in use.
  • Published hierarchy/main hierarchy can be updated in the generated/locked/non-generated state.
  • Regenerating model/clearing model sets the main hierarchy for all dimensions.

In addition to the above features, the following are some additional rows added in the dimension: 

  • Published Hierarchy: Displays the version of the selected dimension published to the end users.  
  • Hierarchy: Displays the versions of the dimension hierarchy. 
    • You can also add new versions from here.
    • After creating and updating the dimension hierarchy, save the hierarchy and navigate to Model > Setup for mapping and publishing the dimension version.

Was this article helpful?