How do you remove the changes made by the Optimize Schema Wizard?

you have to change each lowest level target column of your dimensions.
by default the "customer" level of a customers dimension use the
customers.customerid column, after the optimization, this column is changed
to FactTable.customerid.
So to "rollback" this, you must manually change the column used to the
original one.

other method:
delete your dimensions in the cube only and reassign these dimensions.

"Joseph Ollero" <jollero (AT) wizardsgroup (DOT) com> wrote