Initially, scenario values are not stored and they are an exact mirror of the base values. After you change the scenario values in Excel and submit the changes to the cube, the scenario values are stored, and they are different from the base. You can revert the scenario values back to the base by typing #Revert in the changed cells and clicking Submit Data on the Smart View ribbon.
- In Excel, type #Revert in the scenario cells you want to revert to the base.
- Click Submit Data on the Smart View ribbon.
Initially, the value in sb1 is an exact mirror of the value in base.
Submit a new value, 100, to sb1.
Submit #Revert to sb1.
Refresh the sheet. See that sb1 again reflects the base value of 678.