You are currently offline, waiting for your internet to reconnect

Error message when you try to save a SQL Server 2005 Analysis Services database and a dimension in the database contains a parent/child hierarchy: "Dimension 'DimensionName' cannot be saved"

SYMPTOMS
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.
WORKAROUND
To work around this problem, follow these steps:
  1. Right-click the dimension, and then click Process.
  2. If you receive the following message, click No:
    There are unsaved changes. Would you like to save all changes first?
  3. In the Process Dimension dialog box, click Unprocess in the Process Options column, and then click Run.
  4. Right-click the dimension, and then click Process.
  5. Click Yes if you receive the message that is mentioned in step 2.
  6. In the Process Dimension dialog box, click Process Full in the Process Options column, and then click Run.
  7. Fully process other objects that use the dimension.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Properties

Article ID: 936078 - Last Review: 01/29/2008 21:45:45 - Revision: 1.1

Microsoft SQL Server 2005 Analysis Services

  • kbsql2005bi kbsql2005as kbprb kbexpertiseadvanced kbtshoot KB936078
Feedback