I had a problem with a dimension and so decided to re-created it. Once I was happy with the new dimension I deleted the old and renamed the new to what the old one was called previously. When I try and build my cube I get the following error:
Error 18 Errors in the metadata manager. The dimension with the name of 'dim_product' already exists in the 'Sales_AS' database.
Not sure why this is happening as I thought I'd got rid of all trace of the old dimension. If I rename the new dimension I have no problem.
Is anyone able to explain what's going on here? Thanks.
If you deploy with the default settings the old dimension still exists on the server and if you want too deploay a second one with the same name (but for sure a different id) the server does not allow this.
Try delete the DB from Analysis services and deploy the whole DB again (if possible for your solution).
HANNES
