Passer au contenu principal


Adaptive Insights French

Level Attributes for Reorganization Reporting

This document will cover how to use Level Attributes to create an alternate hierarchy to support a view of the company prior to reorganization.  In the end, the Level dimension will reflect the current state of the company, but in reporting we can view either the current structure or the pre-reorganization structure.

This guide will leverage the existing Level dimension to simplify the setup of the Level Attributes.

  1. Login to Adaptive Insights and navigate to Modeling -> Model Management -> Levels.

  2. Click the Printable View icon printer.png, this generates an Excel file that we will use as the base for the Level Attributes.

  3. Delete all the columns except for “Name” and “Roles up to”.

  4. Save the file as “Pre reorg” and set this file to the side for now.

  5. Navigate to Modeling -> Model Management -> Level Attributes.

  6. Click the import.png icon to import the Level Attributes.

  7. Click the Download Template link, select the “Level Attributes” tab in the downloaded Excel file.

  8. In row 5 in the “Attribute Name” column, enter the name of the attribute.  For this guide, we will use “Pre 2019 Reorg”.

  9. Referring to the file set aside in step 4, copy the items from the “Name” and “Roles up to” columns and paste them to the “Attribute Value” and “Parent” columns starting in row 6.

  10. Delete any parent value of “None”.

  11. Save the file.

  12. On the Import Level Attribute Structure screen with Append selected, click Choose File and browse for the file you just saved  .

  13. Click Upload.

  14. Navigate to Modeling -> Model Management -> Levels.

  15. Click the Printable View icon printer.png, this will create the file that will have a column for the new attribute that we will use to update the Level dimension.

  16. You may have to unhide the column with the attribute name that you used in step 8.

  17. Delete all the columns except for: “Name”, “Rolls up to” and, “Pre 2019 Reorg” (whatever you called the attribute in step 8).

  18. There is no easy way to do this step.  You need to copy all your leaf level values from the “Name” column to the “Pre 2019 Rorg” column. DO NOT copy any Levels that are roll ups.  The idea here is that you only map the lowest levels, then you can see those leaf levels rolled up any way you want.

    1. If you map any roll up Levels, you may get errors when do the reorganization in your Level dimension.  At that time you can manually change the roll up level to be unmapped to the attribute.

  19. Save the file.

  20. Back in Adaptive Insights, click the import.png  icon to update the Levels.

  21. With Update selected, click Choose File.  Browse for the file you just saved, click Upload.

  22. We now have two identical hierarchies.

  23. Now update the Level dimension to reflect the current structure

    1. Option 1: Between steps 18 and 19 you could also change the “Rolls up to” information in the file to give the levels their new parent information completing your reorganization in one step.

    2. Option 2: Using the file saved in step 19, update the “Rolls up to” information for any levels that are being adjusted as part of the reorganization.  Save the file, follow the steps 20-21 to Update your Level dimension.

    3. Option 3: Manually make the updates if there is not too much to change.

  24. In Reporting, you can now build your reports around the current Level dimension or leverage the Level Attribute for the pre-reorganization view of data.  Sample Reports:

Level Dimension pre-reorganization

Level Dimension post-reorganization (4 levels moved)

Report showing both the post and pre reorganization results

  • Cet article vous a été utile ?