Certain Dirty cells in Smartview Adhoc sheet are still dark yellow after data submission
Situation – User is submitting data to the Essbase database using Smartview Adhoc sheet. Some of the cells are still dark yellow, even after the data is submitted to the database. This is confusing the user whether the data really got submitted to the database. Any insights would be appreciated. Some other background information -
- The user is using a smartview Adhoc sheet that was created with multiple lines. There are blank rows in between for readability.
- The user is linking the data to her excel models. So, for data there are references to her excel model.
- There are different kinds of data – such as, dollars, percentage, dates, numbers.