Passing data from one cell to another

Post Reply
samiamsz
Posts: 9
Joined: Wed Sep 02, 2020 3:08 pm
OLAP Product: tm1
Version: 11.3. 0.
Excel Version: 16

Passing data from one cell to another

Post by samiamsz » Wed Sep 16, 2020 4:24 pm

Hey, again im very new to tm1 and coding in general so my quesiton may be very simple.
I need to basically copy data from onoe scenario (exampl: actual) to another scenario (budget)
what i did was decalre two parameters (pSourceScenario, pTargetScenario)
I am confused as to how to actually use them in code so that they point to whatever scenario is being selected as either the source or the targer?

tomok
MVP
Posts: 2751
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: Passing data from one cell to another

Post by tomok » Wed Sep 16, 2020 4:50 pm

This forum is not a substitute for taking a training class or reading the manuals. This is a very basic question that cannot be answered in a simple forum post. It requires a lot of background which you will find either in a training class or in the manuals.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

Wim Gielis
MVP
Posts: 2527
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: Passing data from one cell to another

Post by Wim Gielis » Wed Sep 16, 2020 6:57 pm

You can use Bedrock to do it for you, and learn from that code too. Although it can be daunting for those new to TM1.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 112 TM1 articles and a lot of custom code
Newest blog article: Updating process line numbers with AutoHotKey

Post Reply