You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Smart view reports in hidden worksheets

Received Response
edited Aug 2, 2018 2:36AM in Essbase 11 comments


Smart view reports in hidden worksheets




I am using smart view 710, excel 2016 and essbase version


I need to consolidate several smart view reports in separate worksheets in one file to create a big report but the user does not want to smart view reports to be "visible" to the receiving party of the report.  too many worksheets in a file will create unnecessary confusion and perusal.  It has to be separate worksheets because each is using different essbase cubes.


But if I hide those worksheets, "refresh all" will not work on these worksheets.


Is there a way to hide those smart view worksheets but "refresh all" will still work?

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!