This discussion is archived
2 Replies Latest reply: Oct 16, 2013 2:48 PM by user7729463 RSS

Excel Native Filter and SmartView adhoc

user7729463 Newbie
Currently Being Moderated

I am using excel 2010 with Smartview version we are using is 11.1.2.1.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?

 

thanks!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points