Contains preview content for the upcoming 2019.3 release.
Audience: Administrators who manage the model.
Levels are the organizational structures of your business. For example, levels represent departments, profit centers, cost centers, or geographical regions.
Before You Begin
How You Get There
From the nav menu, select Modeling. From the Levels and Dimension menu, select Levels.
Create Levels Basic Steps
- Choose a method.
- Choose the settings.
- Adaptive Insights adds the level automatically to any level-assigned sheets that have already been assigned to the new level's parent. For user-assigned sheets, you must add the new level to the sheet.
- Create: Select any level from the level hierarchy list. Select Create New Level . The result is a single level that inherits its parent's shared formulas and many settings.
- Clone: From the level list, select a leaf-level (one that you can't expand) and select Clone Level . The result is a level with the same settings, shared formulas, and the data as the original.
- Link: Select any level from the level hierarchy and select Create New Linked Level . Link a level to another instance.
- Import: Create multiple levels or make bulk edits. Each setting is a column in the spreadsheet. See Import Levels.
Clone or Create
If you want to copy either settings or shared formulas, it's best to create a level. Select a child of the level you want to copy, and select Create New Level . Most of the settings update to match the parent.
If you want to copy all the data, it's best to clone. Select the leaf level you want to clone, and select Clone Levels. If you choose a different parent from the Rolls up to drop-down, many of the cloned settings change to match the parent settings. The data still copies.
Choose Level Settings
The settings you choose change the level's behavior and visibility. See Level Fields and Settings for details.
- Enter the Name and Short Name.
- From the Rolls up to drop-down, choose the parent level and select Save.
Levels inherit many of the settings from the parent level, even if you're cloning. You won't see these inherited settings until you save. Shared formulas in unlocked plan versions are always inherited for new levels. See Parent and Reparent Levels for details.
- Skip the Level Owners selection box for now. After you save the level, return to the settings to make more users owners. See Assign Owners to Levels.
- If you have Workflow, the In Workflow setting is Yes from the top level (and downward). If the parent is not in workflow, the field is disabled. Choose:
- Yes if the level is part of the workflow process
- No to remove it from the process.
- From the Currency drop-down, choose a currency. Or, select Add Standard Currency at the bottom of the drop-down list. The exchange rate set in the account settings of each account converts the currency at rollup levels.
- Skip the Versions and Availability section for now. After you save the new level, return and update the level availability. See Change Level Availability in Versions.
- In the Sheets section, use the checkboxes to assign the sheets to the new level. The Sheets section contains a list of all your model's level-assigned sheets.
- Sheet assigned to the parent level are automatically checked for the new level. Uncheck to remove the sheet from the level.
- If a sheet is not assigned to the parent, it's read-only and you can't assign it to the level.
- When you uncheck a sheet, the level doesn't appear on the sheet's columns, rows, or filters.
Link Levels to Another Instance
Linked levels have a link icon in the level hierarchy: .
Link levels in a parent instance to levels in child instances. When you refresh the instances, the data in the parent synchs with the data in the child instance. See Multi-Instance Solutions.
- Multi-instance solution
- Linked levels can be a child of any level in the hierarchy.
- Linked levels must be leaf level. They can't have child levels.
Create Linked Levels
- From the toolbar, select Create New Linked Level . The button is visible for multi-instance solutions.
- In the Level Details settings, choose the instance from the Linked to drop-down. The drop-down appears below the Level Owners and contains all instances that roll up to the current instance.
Create Alternate Level Hierarchies
Tag each level with a dimension or attribute. The tags create alternate rollup values for your level structure. For example, the alternate hierarchy could be regional, functional, or departmental. You can then report totals for each dimension or attribute.
- Level dimensions or level attributes previously created.
Tag Levels with Attributes and Dimensions
- From the hierarchy list, highlight the level to tag.
- From the Level Attributes section or the Level Dimensions section, choose the value from each or any of the drop-down menus. If you don't see drop-downs, you must create the level dimensions or attributes first.
- To use the alternate rollup, reference the dimension or attribute in formulas and reports.
Create Elimination and Trading Partner Levels
Elimination levels is a part of the consolidation solution. Use elimination rules to remove transactions between child levels from the rollup values in levels tagged as elimination levels. For example, Total Company owns company A and Company B. If Company A purchases something from Company B, the transaction is an expense. The transaction in Company B is revenue. If Total Company is an elimination level, you create rules to eliminate the transaction at the Total Company level. The resulting expense and revenue do not roll up to the elimination level and don't affect the rollup level's revenue and expense data.
- A trading partner must have an elimination level as a generation level.
Make Elimination Levels
Elimination levels have an icon in the level hierarchy:
- From the level hierarchy, highlight any level.
- In the Elimination Settings, select the Elimination level checkbox.
Transactions between descendants tagged as trading partners are eliminated at this level after you set up the elimination rules.
Make Trading Partner Levels
The label, Elimination Trading Partner, is set in your General Settings. It can be any label.
- From the level hierarchy, highlight any level.
- In the Elimination Settings, select the Elimination Trading Partner checkbox. The setting is available only if the one of the level's generations is an elimination level. All child levels of a level tagged with Elimination Trading Partner are also tagged.
- From the level list, highlight the level.
- Update the settings. See the preceding section.
Pay attention to the messages and warnings and follow the prompts to save your changes. Level edits may affect data visibility and flow.
Parent Level Settings
When you edit parent levels, its child level settings may also update. See Inherited or Cloned Level Settings and Data.
Best Practice: After you make changes to the parent level, check the settings of its child levels.
Top level settings are different from other level settings:
|Rolls up to||Read-only. The top-level rolls up to None.|
|Level Owners||Anyone who owns the top level owns all levels. See Assign Levels to Owners.|
|In Workflow||If you use workflow, the workflow setting for the top-level is Yes and read-only. In the workflow process, you can mark the top-level level In Progress or Approved, but you can't submit or reject it.|
|Currency||Read-only. The top-level currency is always the corporate currency, chosen when your instance was first set up. See the FAQ.|
|Versions and Availability||Read-only for all versions. The top-level is always available in all version.|
|Sheets||If you remove a sheet from the top-level, you hide the sheet and its data from all users, including you.|
Copy Shared Formulas for New Levels
New levels inherit the shared formulas of the parent level. See Shared Formulas.