Article ID: 936078 - View products that this article applies to.
In SQL Server Business Intelligence Development Studio, you open a Microsoft SQL Server 2005 Analysis Services database. A dimension in the database contains a parent/child hierarchy. You specify a unary operator column for the parent attribute. You change, add, or delete a user hierarchy in the dimension. When you try to save the changes, you receive the following error message:
Dimension 'DimensionName' cannot be saved because of the following errors: Internal error: An unexpected exception occured.
To work around this problem, follow these steps:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.