Page 1 of 1

add dimension to existing cube

Posted: Mon Dec 15, 2014 7:02 pm
by elee123
Hi Everyone,
Can we add a dimension to an existing cube? If not, why can't we do so?

Re: add dimension to existing cube

Posted: Mon Dec 15, 2014 7:07 pm
by declanr
Performance Modeller allows you to do so but you need to obviously map all of your existing values to just 1 element in the new dimension and you need to be careful of the implications on rules for that cube and any associated TI processes in or out.

Its often easier/more robust to just ascii out your old values and build a new cube.

If you go the PM route though i haven't done it in a while but think you just open the cube view and then drag your new dimension over to a row/column etc.

Re: add dimension to existing cube

Posted: Mon Dec 15, 2014 8:20 pm
by elee123
Thanks Declanr.

Re: add dimension to existing cube

Posted: Mon Dec 15, 2014 11:26 pm
by RJ!
It was noted in a previous thread that for you to do this via PM, the target cube has to be very small otherwise it kicks up errors.

If you have quite a lot of data in it, best to do as above.