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 happens when KepionSI doesn’t have permission to write into the sys tables. Please follow our setup guide and ensure all required permissions have been granted.

This particular issue should be resolved if you run the following query:

USE MASTER;
GO

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