When attempting to submit data through Smart View the following error occurs:
Error 1020043 – You do not have sufficient access to perform a lock on this database.
The issue can be reproduced at will with the following steps:
1. Open Excel.
2. Connect to the Essbase server using Private connection.
3. Perform Adhoc analysis.
4. Enter data and submit
Delete the security the filter in EAS for that user in the application after taking backup of the same.
1. Open EAS Console > Expand Essbase server > Expand Application > Right Click on the database > Edit > Filters.
2. Select the user from the Filter Name and edit.
3. Take backup of the “Filter Rows” and delete Read and Write access only.
4. Save it
Log into the Planning as admin and create a security filter for that user.
Now that user can submit data from Smart View without any issue.