Specifying the Role Cache Refresh Frequency

By default, Microsoft SQL Server Analysis Services updates the membership of Microsoft Windows users and groups in database roles every 10 minutes. Although the default value of 10 minutes is appropriate in most environments, the frequency at which the role cache is refreshed may have to be increased if role membership frequently changes.

Modifying the Role Cache Refresh Frequency

To modify the default setting for role cache refresh, change the Security \ RoleCacheExpirationInterval server configuration property. To access this property, right-click the instance of Analysis Services, click Properties, and then locate this property on the Security page.