Can't Add Dimension Member in Modeler

Author: Joyce Zhou

Symptom

When adding dimension members, ‘phantom’ members show up. The green circle spins forever, and you can't modify any fields.

Resolution

This issue arises when KepionSI doesn’t have permission to write into sys tables. Please refer back our setup guide and ensure all required permissions have been granted.

1. In SQL Management Server Studio (SSMS), right-click the server and select New Query.

2. Run the following script to resolve the issue:

USE MASTER;
GO

GRANT VIEW SERVER STATE TO [<KepionSI>];
GO