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.
To resolve this error upgrade to the latest service pack for your version of SQL Server.