Question: Can I import data into a scenario (vs. into the plan of record?)
Answer: No, regardless of the import source (Excel, ODBC,...), data can only be imported into the plan of record.
However, you can import data into the plan of record and then create a scenario based on those data:
- First, create a scenario based on the plan of record to serve as a backup.
- Import the desired data into the plan of record.
- Create a scenario based on the plan of record now containing your newly imported data.
- If you want to restore your previous data, submit the scenario you first created as the plan of record.