How to create custom consolidations in TM1
?
1 like?631 views
In some cases you want TM1 to create subtotals which are not predefined by the administrator.This can be of great help for both the End Users and the developer in analysing data. Unfortunately you can not save these custom roll up. In the video we will show you how to create a custom subset you can save.
How to create custom consolidations in TM1
- 1. How to Create Custom Consolidations in TM1
- 2. How to add up Region A and Region B? www.sonum-int.com How to create subtotales wich are not predefined by the administrator?
- 3. Rollup No se puede guardar rollups personalizados
- 4. Double click on Region www.sonum-int.com To roll up of a Region A and a Region B Double click on: Region
- 5. Select Elements www.sonum-int.com Select Region A and Region B and click on the Green Ok sign
- 6. Save Subset www.sonum-int.com Save the subset and click on both ¡°Ok¡±
- 8. Create new Subset www.sonum-int.com Choose the subset wich was just created and click on ¡°Ok¡±
- 9. Result www.sonum-int.com Subset ¡°My_Cons¡± created. You can save the subset as you like
Editor's Notes
- Welcome to our How to video. In this video we will show you how to create saveable ConsolidationsTM1.
- In some cases you want TM1 to create subtotals which are not predefined by the administrator. This can be of great help for both the End Users and the developer in analysing data. In our how to video Create User-Defined Consolidations in TM1 we showed you how you can do it on the fly. Unfortanately you can not save these custom roll up. In the next slides we wil show you how to create a custom sub set you can save.
- In our example we want a roll up of Region A and Region B. To do so. Double click on the dimension you want your custom roll up. In this case Region.
- The subset editor is now open. select Region A and Region B Next click on the Green OK sign
- Save the subset and click on OK and on the ok from the subset
- Open an subset from the dimension and expand to all. Or select any subset in which you want to add your custom subset in. Next edit and insert subset
- Now choose the subset we just created and click on OK
- You just added our My_Cons subset into an other subset. You can save the subset as you like.
- And this is how it looks in your view
- Esperamos que este video les haya sido de ayuda. Para m¨¢s consejos y trucos, por favor visite nuestra pagina web. We hope this video has been helpful to you. For more Tip and trick please visit our website.