Budget Versions in TM1

Post Reply
rasika
Posts: 4
Joined: Wed Sep 15, 2010 7:12 am
OLAP Product: tm1
Version: 9.4
Excel Version: 9.4mr1

Budget Versions in TM1

Post 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.
Gabor
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

Post by Gabor »

You should simply add one more dimension to house the different versions of data.
Wim Gielis
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

Post 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 ...
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
rasika
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

Post 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? :oops:
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 .
Andrew_M
Posts: 6
Joined: Thu Jun 07, 2012 12:47 pm
OLAP Product: Tm1
Version: 10.1
Excel Version: 2k10

Re: Budget Versions in TM1

Post 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.
Post Reply