Regression Analysis on TM1
-
- Regular Participant
- Posts: 269
- Joined: Tue Apr 21, 2009 3:43 am
- OLAP Product: Cognos TM1, Planning
- Version: 9.1 SP3 9.4 MR1 FP1 9.5
- Excel Version: 2003
Regression Analysis on TM1
Has anyone tried using regression analysis on TM1? Since this is much more of a math approach on analysis of data, I just want to check out if anyone has experienced doing one and any tips on creating the cubes.
-
- Posts: 70
- Joined: Thu May 22, 2008 3:38 pm
- Eric
- MVP
- Posts: 373
- Joined: Wed May 14, 2008 1:21 pm
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2003
- Location: Chicago, IL USA
Re: Regression Analysis on TM1
I have done some linear regression models and I recently began working on developing a monte carlo model. Do you have any specific questions.
Regards,
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1
Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1
Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
-
- MVP
- Posts: 3698
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Regression Analysis on TM1
Hi Eric,
As a past user of both @Risk and Crystal Ball for Excel Monte Carlo analysis I'm quite interested in what your approach it with Monte Carlo and TM1 (do the iterations in Excel with addin, with custom VBA or in TI ..)
Are you able to elaborate or even post a model?
As a past user of both @Risk and Crystal Ball for Excel Monte Carlo analysis I'm quite interested in what your approach it with Monte Carlo and TM1 (do the iterations in Excel with addin, with custom VBA or in TI ..)
Are you able to elaborate or even post a model?
- Eric
- MVP
- Posts: 373
- Joined: Wed May 14, 2008 1:21 pm
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2003
- Location: Chicago, IL USA
Re: Regression Analysis on TM1
My model is just in the beginning stages, but I can tell you I am planning to have all the iterations are in a TM1 cube.
Regards,
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1
Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1
Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003