Symptoms
When the user tries to connect to a pivot table they receive the follow error message:
Complete text from error message:
The 'GL Account' parent-child dimension has dimension security defined on the key attribute, which is not allowed. You could, alternately, define the equivalent dimension security on the parent attribute.
Resolution
To resolve this error upgrade to the latest service pack for your version of SQL Server.
Comments