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.
What-If analysis with TM1.
-
- Posts: 29
- Joined: Tue Jun 22, 2010 4:01 pm
- OLAP Product: IBM TM1
- Version: 9.5
- Excel Version: 2007
- jim wood
- Site Admin
- Posts: 3958
- 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.
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.
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.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- 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.
Hi Deepu,
Depending on your needs:
Hope this helps.
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).
- Use sandboxes
- Use driver cubes and rules
- Use TIs
- Spread values with the many spreading functions.
- None of the above
- All of the above
Hope this helps.
Cheers!
--
Claude-Sebastien Jean
Senior Consultant in Information Technology
Keyrus Canada
www.keyrus.ca
--
Claude-Sebastien Jean
Senior Consultant in Information Technology
Keyrus Canada
www.keyrus.ca