What-If analysis with TM1.

Post Reply
deepu_sree
Posts: 29
Joined: Tue Jun 22, 2010 4:01 pm
OLAP Product: IBM TM1
Version: 9.5
Excel Version: 2007

What-If analysis with TM1.

Post by deepu_sree »

Hi All,
Can somebody give me a few ideas/inbuilt mechanisms in TM1 which help you do What-If analysis?

I'm completely clueless about What-If analysis and thats why such a vague question. Sorry about it.

Regards,
Deepu.
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: What-If analysis with TM1.

Post by jim wood »

Hi Deepu,

There are some elements you can do within Excel, for example spreading and there are things you do via TM1 Contributor, but on the whole TM1 itself is like a starting block. If you want it to do something you build it by using either rules (calculation language) or TI (Turbo Integrator).

For more information might I suggest you look at OLAPedia or check out the IBM web site,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
csjean
Posts: 40
Joined: Mon Mar 01, 2010 2:53 pm
OLAP Product: TM1
Version: 9.5 9.5.1 9.5.2
Excel Version: 2007

Re: What-If analysis with TM1.

Post by csjean »

Hi Deepu,

Depending on your needs:
  • Why you need the what-if analysis
  • What you will do with it once it's finished
  • What kind of "ifs" we are talking about (driver based or "finger" based variations).
There are a lot of things you can do with TM1 and a lot of different ways to do them:
  • Use sandboxes
  • Use driver cubes and rules
  • Use TIs
  • Spread values with the many spreading functions.
  • None of the above
  • All of the above
As Jim said, you should lookup IBM's website and familiarize yourself with the different TM1 features.

Hope this helps.
Cheers!

--
Claude-Sebastien Jean
Senior Consultant in Information Technology
Keyrus Canada
www.keyrus.ca
Post Reply