Transformer: Automatically remove all categories

[camjai]

Is there a way to automatically remove all the categories in the model before the Cube is rebuilt? So far the only way I have found to do this is manually remove and re-add the levels from the dimension.

I know you can disable the adding of new categories when the data source changes. But I have new categories in the datasource that need to REPLACE old categories in the cube and not just add them. When it adds those new categories it results in Uniqueness violations.

 

[yksvaan]

The easiest way is that you save your model without any categories. If you build it by hand, don't save it. If your cube build uses command-line transformer don't put the -S switch there. Nor if you build it manually, don't save it. Always save before the build.

But I'm not sure if your real problem is that. You should on a unique level check Move, which is just to the right of Unique. Then categories will move automatically to the newest parent catgory.

Cheers