Page 1 of 1
Budget Versions in TM1
Posted: Fri Jan 10, 2014 11:23 am
by rasika
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.
Re: Budget Versions in TM1
Posted: Fri Jan 10, 2014 2:09 pm
by Gabor
You should simply add one more dimension to house the different versions of data.
Re: Budget Versions in TM1
Posted: Fri Jan 10, 2014 8:13 pm
by Wim Gielis
Gabor wrote:You should simply add one more dimension to house the different versions of data.
Or, depending on the case, merge Scenario's and Versions into 1 dimension.
n Budget Version 1
n Budget Version 2
n Budget Version 3
n Forecast Version 1
n Forecast Version 2
n Actual
n ...
Re: Budget Versions in TM1
Posted: Mon Jan 13, 2014 10:45 am
by rasika
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 .
Re: Budget Versions in TM1
Posted: Mon Jan 13, 2014 11:17 am
by Andrew_M
rasika wrote:dimension would suffice my requirement.
Supposing you have Version dimension in your Tm1 model with the element Budget Version which you described.
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.