Passing data from one cell to another

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

Posts: 2759
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

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

Wim Gielis
Posts: 2554
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.8
Excel Version: Microsoft 365
Location: Brussels, Belgium

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 ==> 112 TM1 articles and a lot of custom code
Newest blog article: Updating process line numbers with AutoHotKey

Post Reply