ANS-1233 · ROLES, PERMISSIONS & SECURITY
Why Do SuiteAnalytics Connect Queries Show Different Results for Non-Admins?
Understand why custom roles with SuiteAnalytics Connect access may encounter data discrepancies compared to Administrator role queries.
Short answer
Certain records within the SuiteAnalytics Connect schema are exclusively accessible via an Administrator role, even when custom roles are granted relevant permissions. This limitation causes non-admin users to observe discrepancies between data in NetSuite and data retrieved through SuiteAnalytics Connect queries, making Administrator access essential for comprehensive data retrieval.
Scenario
Users running queries through SuiteAnalytics Connect may observe inconsistencies in the data retrieved compared to what is displayed directly within NetSuite. This issue specifically affects users assigned to custom roles, even when those roles have been configured with seemingly appropriate permissions for the Connect Service. The discrepancy arises when different users, particularly those with non-administrator roles, execute the same queries.
Solution
The discrepancy in SuiteAnalytics Connect query results for non-administrator roles stems from a fundamental access limitation. Certain records within the Connect schema are exclusively obtainable when queries are executed using an Administrator role. This holds true despite the configuration of seemingly appropriate permissions for custom roles within NetSuite. Consequently, users assigned to custom roles with access to the Connect Service will likely encounter a difference between the information displayed in NetSuite and the information pulled when running a query using SuiteAnalytics Connect. To ensure complete and consistent data retrieval, queries involving these specific records must be performed by a user with an Administrator role.
Expert NetSuite Support
Need help with this NetSuite issue?
Roles, Permissions & Security consulting and configuration support