Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Split Behavior when Importing

Question

How do imports work when they contain splits? I keep receiving an error message when trying to import a file with splits. What might be causing the error?

Answer

  1. If the account/level/version combination to which you are importing contains no data (account is blank in all time periods), any splits in the import template are created automatically.
  2. If the account/level/version combination to which you are importing contains data (in any time period in the versions), the following is true:
     
    • If you are importing one split to a particular account/level/version combination, you will get the Warning message and the data will be placed in the unsplit account.  If you want to create a new split/tag the data with the dimension, you need to go to that location in the sheet and manually add one split.  The reason that you have to do this is because you have to specify in which split the data in the main account is placed and how it is labeled. 
       
    • If you are importing more than one split to a particular account/level/version combination, you will get an Error message and you have to create the first split manually in the sheet.
       
    • A warning message means that the data still imported. If there is an error message, the data is NOT imported.  The presence of a single Error will cause the ENTIRE file upload to fail, not just the line(s) containing the Error.
       
  3. An import that contains blank Split Labels will create new splits in the system for an account that already contains splits. The system does NOT match and align all blank split labels associated with a particular level/account combination.
     
  4. If you are importing an entry that is tagged with a dimension and an entry that does not have an associated dimension or a Split Label, the system will NOT import the value that does not have an associated dimension or a Split Label. In this scenario we would recommend creating a dimension value called “_” and associate all blank entries on the import with the underscore.
     
  5. Erase Actuals will erase splits if the process of erasing Actuals causes the split to become empty. An empty split is one where there is no value nor cell note. Please note, splits that are already empty will remain untouched.

 

  • Was this article helpful?