cancel
Showing results for 
Search instead for 
Did you mean: 

Best Approach for deleting dimension from a Model which is already in Production

Former Member
0 Kudos

Hello Experts,

We are already live and now the requirement is to remove 2 dimension from a particular model. We don't want to change any nomenclature for the model.

What would be the best approach to do this?

What happens to data? how do we handle that?  how to handle data in production?

what happens to transports ? how do we handle that?

Is this the correct approach? if yes, what more? if no, what is correct approach?

As per   https://scn.sap.com/thread/3504555 and vadims reply :

"The simple way to change the dimensions in the cube is to copy existing original cube to some temporary cube, delete original cube, then create a new cube with the required set of dimension and with the name of original cube. Then using script logic copy data from the original copy to the new cube. You can create properties in the copy of the original cube to define transformation logic for script.

The technical name of the result will be different but what's the issue!


If we create a copy of original, and then delete the original model,are we going to delete the original model from production as well ? how are transports going to work?

If we are going to delete the original cube, whats the use of transformation to load production data to new model since there wont be any source cube in production as we need to transport the new model and for this we will have to delete the original model since the name of model is same? or is it we can transport same name model since the tech names are different? how does this work?

I am really confused since our model is already in production and we need to make this big change.

Regards,

Accepted Solutions (0)

Answers (1)

Answers (1)

akos_beres
Contributor
0 Kudos

BPC,

Vadim's case was for you to do all of that in production. If you do that your transport landscape will not work going forward unless you bring back your newly created env\model into Dev. There is a debate on how to do that .. SAP recommends transports ... I have done UJBR before but you have to be careful and obviously you are on your own to fix issues.

If you want to keep the your transport landscape, the only way to do this is initiate it from DEV and promote it through your landscape... you will need to reload data either from the old source or dump your data out and reload it once the new model is in Prod.

I don't think there is an easy way ... I would probably create a new model in dev and cutover with data once the model is in production ... then delete the old.

Akos

former_member186338
Active Contributor
0 Kudos

Agree!

Removing dimensions is a disaster in general All reports will be invalid! Assume it as small project restart...

Vadim

akos_beres
Contributor
0 Kudos

Vadim ...I agree ... not to mention logic and might even be security or work status ...

I guess my first question should have been .. is it really that bad with those extra dimensions ... you can just use dummy members for them for a while when you load data ...

Akos

former_member186338
Active Contributor
0 Kudos

To my mind if the dimensions are useless - then you have to remove! It may be better to prepare a new environment to test everything...