When working with member security to manage users’ access to cube data, Smart View users may notice their ability to suppress “No Access” is greyed and not available for Essbase connections. This post will walk through enabling smart view no access suppression.
Regardless of what suppression preferences are checked, users see the following when they open an ad-hoc grid where they are not permitted to read data:
Moreover, as users drill down, they must manually adjust for members they have no access to read. This can become frustrating for users, especially in more complicated member security environments.
The No Access suppression filter is not available at a user preference level, but fortunately there is an Essbase configuration setting that will allow Smart View users to suppress #NoAccess members automatically: SUPNA
This modification does not enable the ‘No Access’ user preference in Smart View, but instead ties the same functionality to the ‘No Data/Missing’ checkbox. From Oracle’s documentation:
SUPNA Controls whether the Suppress #Missing Rows option in the spreadsheet interface suppresses the display of cells for which a user has no access (in addition to suppressing missing rows).
To enable this configuration setting, open essbase.cfg. In EAS, right click EssbaseCluster and select Edit/Properties to open Essbase Server Properties. Using the ‘Environment’ tab, then simply add the line SUPNA ON to the bottom of your config file, as shown below:
With this adjustment in place, apply changes, save and close essbase.cfg. Essbase Analytic Server reads the configuration file only once, at startup, so Analytic Server will need to be restarted for this change to take effect.
After restarting the service, a user can enable suppression of ‘No Access’ by checking the preference to suppress ‘No Data/Missing’:
Connecting to the same ad hoc grid used above will produce no rows because suppression is removing #NoAccess from the query.
SUPNA is not able to be set up at the cube level, and must be applied to all applications within the cluster managed by analytics server. The suppression will only apply when users have enabled #Missing row suppression.
Hopefully these steps are helpful. Do you also experience slow performance in Smart View? If so, review the following resolutions:
- Speed up Smart View by over 2x using the Smart View Toolkit Excel Add-In
- Resolve common root causes for Smart View performance issues
Please contact our team for further support.