COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: sanchoniathon on 15 Apr 2010 02:31:15 PM

Title: How to add new dimension to existing cube ?
Post by: sanchoniathon on 15 Apr 2010 02:31:15 PM
Hi to all,

I have this existing cube with 6 dimensions.
I create this new dimension.
How do i associate thie newly created dimension to the existing cube ?

Thanks !
Title: Re: How to add new dimension to existing cube ?
Post by: MichelZ on 16 Apr 2010 12:35:14 AM
Hi,

The only way you can add a new dimension to a cube in TM1 is by rebuilding the cube.
So you need to
- export the current cube contents and save the rulessheet (if any) to a notepad file,
- delete the current cube,
- recreate the cube with the additional dimension,
- add the rules from the notepad file (check for changed DB references because of the additional dimension),
- reload the exported data and
- recreate views and apply security (if appliccable).

Instead of reloading the exported data (where you need to map the data to an element in the newly added dimension), you can also reload - if available - the data from the sourde DB and now fully map this dataload including the new dimension.

Michel
Title: Re: How to add new dimension to existing cube ?
Post by: sanchoniathon on 19 Apr 2010 08:58:12 AM
Thanks for the information.