TM1 SandBoxes Approving commits?

Post Reply
User avatar
damientaylorcreata
Posts: 86
Joined: Mon Apr 13, 2009 8:47 am
OLAP Product: Cognos TM1
Version: 9.4
Excel Version: 2003 and 2007
Location: Sydney, Australia
Contact:

TM1 SandBoxes Approving commits?

Post by damientaylorcreata »

Hi Guys,

We are wanting to create a process where a GBU head is able to enter a project budget and allocate portions of the budgetted costs out to the appropriate departments (GSF's). We would then like the individual department heads to look at those figures and propose changes to those budget figures which can then be reviewed and committed back to the main base dataset. My thoughts are that we could use Sandboxes as follows:

1. GBU Head creates cost budget at the project level and assigns the costs out to the relevant departments where costs are expected to occur
2. Department Head creates sandbox based on the base dataset and then reviews figures and if appropriate propose alternative figures.
3. GBU Head is somehow in a position to review all proposed changes and commit any new figures that seem appropriate

Does this sound possible or do I need to consider an alternative approach.

Keep in mind that we are currently on TM1 9.4, however I do plan to upgrade to 9.5.1 in which case I should be able to start using sandboxes.

Any thoughts/ideas would be highly appreciated.

Thanks,
Damien
Damien Taylor
User avatar
Martin Ryan
Site Admin
Posts: 1989
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: TM1 SandBoxes Approving commits?

Post by Martin Ryan »

First big problem - sandboxes are private. You can't share data between people.

Personally I'd use a dimension called "Versions" and use TI to deal with the approvals.

Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: TM1 SandBoxes Approving commits?

Post by tomok »

Sandboxes are not, and never were intended to act as, a workflow vehicle. They are simply a way for users to try out their changes to a model before officially committing them.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
damientaylorcreata
Posts: 86
Joined: Mon Apr 13, 2009 8:47 am
OLAP Product: Cognos TM1
Version: 9.4
Excel Version: 2003 and 2007
Location: Sydney, Australia
Contact:

Re: TM1 SandBoxes Approving commits?

Post by damientaylorcreata »

Thanks Martin... In that case I will try the version dimension concept. Thanks..
Damien Taylor
Post Reply