I am using excel 2010 with Smartview version we are using is 220.127.116.11.103 (Build 100).
I have an SV adhoc, it retrieves data correct and runs fine. when I apply the native excel filter (menu bar Data ->Filter (Ctrl+Shift+L) to filter the data (i.e. account) and it shows me the data I need. when i click on "Essbase" Refresh again, the filter that was applied disappeared.
is there anyway to make sure the excel filter will stay even after Essbase refresh?