How to add new dimension to existing cube ?

[sanchoniathon]

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 !

[MichelZ]

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

[sanchoniathon]

Thanks for the information.