Hi Everyone,
I want to know ,is there any versoning system present in TM1?
As in If one my user want create Budget Version say "Budget Version 1" and at the same time another user wants to create another version of the same data say "Budget Version 2".
Using sandbox it is possible but Is there any other way to do this?
Basically I want to know collaborative feature of TM1.
Quick help will be appreciated.
Budget Versions in TM1
-
- MVP
- Posts: 170
- Joined: Fri Dec 10, 2010 4:07 pm
- OLAP Product: TM1
- Version: [2.x ...] 11.x / PAL 2.0.9
- Excel Version: Excel 2013-2016
- Location: Germany
Re: Budget Versions in TM1
You should simply add one more dimension to house the different versions of data.
-
- MVP
- Posts: 3105
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Budget Versions in TM1
Or, depending on the case, merge Scenario's and Versions into 1 dimension.Gabor wrote:You should simply add one more dimension to house the different versions of data.
n Budget Version 1
n Budget Version 2
n Budget Version 3
n Forecast Version 1
n Forecast Version 2
n Actual
n ...
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Posts: 4
- Joined: Wed Sep 15, 2010 7:12 am
- OLAP Product: tm1
- Version: 9.4
- Excel Version: 9.4mr1
Re: Budget Versions in TM1
Thank you very much for quick reply.
But I am very new to TM1 and I don't understand how adding one dimension would suffice my requirement.
Whenever user wants to do what if analysis and want to save that analysis he will need to add an element(i.e. Budget Version) in the dimension ,is it?
If yes ,then after selecting added element... facts value won't come as there won't be any facts value for that element.
Could you please explain, that would be really helpful .
But I am very new to TM1 and I don't understand how adding one dimension would suffice my requirement.
Whenever user wants to do what if analysis and want to save that analysis he will need to add an element(i.e. Budget Version) in the dimension ,is it?
If yes ,then after selecting added element... facts value won't come as there won't be any facts value for that element.
Could you please explain, that would be really helpful .
-
- Posts: 6
- Joined: Thu Jun 07, 2012 12:47 pm
- OLAP Product: Tm1
- Version: 10.1
- Excel Version: 2k10
Re: Budget Versions in TM1
Supposing you have Version dimension in your Tm1 model with the element Budget Version which you described.rasika wrote:dimension would suffice my requirement.
My suggestion is to add additional element in the Version dimension for instance Budget Version 1 but it is not
enough (this is step #1). This step you can make using the internal Tm1 functionality: Server Emplorer->
Right Mouse Button Click on a dimension name-> Edit Dimension Structure.
Then you can create TI script (Turbo Integrator process) which will copy data in the cube ( for instance Budget Cube)
from Source Version (parameter 1) to Target Version (parameter 2) this is step #2.