Is there a way to update the default POV for a new Ad Hoc Analysis in Smart View in Excel?
Is there a way to set the default POV when adding a new Smart View Ad Hoc Analysis to a tab in Excel? Currently, the POV lists the dimension names. It would be more efficient to set certain dimensions to a lower-level member automatically or the current year instead of change all dimensions each time a new ad hoc is created.
I briefly looked into Smart View Tab --> Functions-->Manage POV, but the updates made did not seem to stick when Excel was closed and restarted.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):