You may refresh the data in an ad hoc view, but you cannot change the layout on the sheet.
To edit the layout of the view (for example, add or remove columns), you must publish the view to BI Answers. Open the analysis in BI Answers and make the required changes. See the documentation in Oracle Business Intelligence Answers for assistance. Then insert the updated view into Smart View.