Symptoms

When the user tries to connect to a pivot table they receive the follow 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.