Cube dimension modifications
- Oct. 25, 2016
 | Example files with this article: |
Introduction
It is with great pride that I reach a milestone of 100 TM1 articles on my website :-) It has been an interesting journey the last 7 years, trying to spread the knowledge of this software among my regular blog visitors. I hope you all like the articles.
For this 100th article, I wanted to share with you a somewhat bigger TI process, that is very generic and useful in any TM1 model. In fact, it builds on the same principles that I explained and showed in this recent article. That article was about how to add a dimension to a cube. But I wanted to go further… So here is a nice TI process for you that can:
- mode 1: add a new dimension
- mode 2: delete an existing dimension
- mode 3: swap the order of 2 dimensions
- mode 4: switch a dimension with a new one
Just as before, there are 3 important notes regarding BACKUP - if applicable - it is things the process does not take care of:
- backup your n-level data first
- backup your rules first
- backup your cube views first
The TI process contains 5 parameters:
| Parameter | Type | Default Value | Prompt Question |
| pMode | String | Execution mode ( 1-2-3-4 or other, see inside process ) | |
| pCube | String | Cube name ? | |
| pDim1 | String | Dimension 1 name ? | |
| pDim2 | String | Dimension 2 name ? | |
| pIndexOfNewDim | Numeric | 0 | Index of dimension in the cube ? |
All code is in the Advanced > Prolog section of the process. You can download the TI process at the top of the page.
That's it, article number 100 is born ! :-)
