Link Modeled or Cube Sheet Data to Another Account

Prerequisites

• See Concept: Linked Accounts,  Example: Link Accounts for Expenses, and Example: Link Accounts for Dimensions and Revenue.
• Required permission: Model Management Access > Model.
• To link accounts, you may have to change multiple account settings that affect how data is tracked and displayed in sheets, reports, and charts. 

Navigation

To link accounts, you may need to edit the source and the destination account:

To get to the custom, general ledger, or assumption accounts:

 From the nav menu, select Modeling. From the Accounts menu, choose: General Ledger Accounts, Custom Accounts, or Assumptions.

To get to cube or modeled accounts: 

Basic Steps

1. Confirm the destination account is leaf level.
2. Match the account Type setting of the source and destination account.
3. Verify the Time rollup setting of the source and destination account if necessary.
4. Check and change other settings in both the destination and source account.
5. Change the Type of the destination account to Link:
   1. Choose the cube or modeled sheet and account.
   2. Optional. Choose dimensions to filter the data. 
6. Save.

Confirm the Destination Account is Leaf Level

You can only link destination accounts that are leaf level. See Concept: Accounts for more on the account hierarchy.

A leaf level account has no child accounts. 4100 Product Revenue is a rollup - not a leaf level. This account has an expand arrow next to it. 4110 Product Revenue - Tops, 4120 Product Revenue - Bottoms, 4130 Product Revenue - Accessories are leaf level accounts. They do not have child accounts. You can set these as destination accounts for your link. 

Match the Account Type Settings

The destination account must match the source account's type: periodic or cumulative. See Change the Account Type Setting.

Check the source and the destination account and update if necessary:

1. From the account tree, select the account. 
2. In the settings, find the Type:

• If they're the same, link the accounts.
• If they're different, the source account won't be available from the Links to drop-down.

3. If necessary, change either the source or the destination account's Type setting so they match.
   If the linked account is a general ledger account, you can only change the account Type setting of the source account.
4. Save your changes.

Match the Time Rollups

Match the accounts by changing the Time rollup for either the source or the destination account. Matching a general ledger account's Time rollup setting is different because the Time rollup isn't visible.

Check and Change Other Settings

In the destination account: 

• Remove any master formula in the Data Type section.
• Change the Data Entry Sheet Type setting to Standard (cannot be cube-entered)

Change the Type to Link

You're ready to link the accounts.

1. From the account list, highlight the destination account. 
2. For Type, select Link and select Yes:
   
3. Choose the source sheet and account.
   1. Once you confirm, you see more fields:
      • Links to: Choose the sheet and the source account. 
      • Linked filters: Choose dimensions from the sheet to filter the data (see the following section: Use Dimension or Attribute Filters to Limit Data).
        
   2. Select the Edit link next to Linked to. These drop-down menus appear:
      
      • Select a model: Choose a cube or modeled sheet, also known as models.
      • Select an account: Choose from the list of accounts in the cube or modeled sheet you selected. The menu is empty until you choose a sheet.
4. Save.

Use Dimension or Attribute Filters to Limit Data

Filters limit the data from the source account by attributes or dimensions that are in the source account's sheet. If you're pulling data from a revenue cube account, you can filter by a product category dimension, such as Tops. Only the revenue tagged with that category populates the destination account. See Concept: Linked Accounts.

1. From the account list, select the destination account. 
2. In the account details, select Edit next to Linked filters. 
   
   For each available dimension or attribute in the source sheet, you see a drop-down menu. Each menu is labeled with the name of the dimension or dimension attribute; in this case, color, customer, group, product, and size.
   
   Each drop-down includes a list of all the values for that dimension or dimension attribute. In this case, the product categories are Tops, Bottoms, Accessories and Services:
   
3. Choose one value for each dimension. If you don't want to filter by a dimension, don't choose anything from the drop-down.
4. Save. 

Link or Unlink the Accounts for Actuals Versions

You can link some accounts for actuals and planning and other accounts for only plan versions. Certain accounts are better left unlinked for actuals:

• If you import actuals data from another general ledger source, not the modeled or cubed account in Adaptive Planning.
• If the actuals data for your destination account is not modeled in {{corp}}.
• If you don't have actuals for the source accounts.

Use the Actuals overlay setting in your destination account to make your choice:

Enable actuals for link: With this option, you enter or upload data separately for the source and destination accounts in actuals versions. You can also leave either or both accounts blank in actuals.

Show actuals if the linked account has them: This option only works if the source account is a cube account or if it's a modeled account that has actuals.

• If the source account has actuals, you enter data in the source account of actuals versions and it populates the destination account in actuals versions, like it does in plan versions.
• If it doesn't, the accounts remain unlinked for actuals versions. You enter or upload data separately for the source and destination accounts for the actuals versions.