Regression Analysis on TM1

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

Post by appleglaze28 »

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.
Herman Moller
Posts: 70
Joined: Thu May 22, 2008 3:38 pm

Re: Regression Analysis on TM1

Post by Herman Moller »

Read the following post.

http://forums.olapforums.com/viewtopic. ... sion#p1775

HTH

Herman
User avatar
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

Post by Eric »

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
lotsaram
MVP
Posts: 3666
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

Post by lotsaram »

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?
User avatar
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

Post by Eric »

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