Variable of TI process and Perspectives for Excel

Post Reply
Maxon
Posts: 13
Joined: Thu Jun 03, 2010 8:44 am
OLAP Product: TM1, Transformer
Version: TM1 9.5
Excel Version: 2007

Variable of TI process and Perspectives for Excel

Post by Maxon »

TM1 Guru, I need help!

I create TI process. Result of TI process is number.I put number to TI Variable.
Can I connect through Perspectives for Excel to this variable(to Result of TI process) and show this Variable in Excel?

Thanks in advance:)
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Variable of TI process and Perspectives for Excel

Post by Alan Kirk »

Maxon wrote: I create TI process. Result of TI process is number.I put number to TI Variable.
Can I connect through Perspectives for Excel to this variable(to Result of TI process) and show this Variable in Excel?
Many sites have a cube which is used to control the execution of TI processes or chores. Those cubes contain things such as parameters that are read in the Prolog. They can also be used to store output from a process.

The easiest way to do what you're after is to write the result of the process to a control cube via CellPutN or CellPutS, in which case the user can simply read the value from the control cube via a standard DBRW formula.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Maxon
Posts: 13
Joined: Thu Jun 03, 2010 8:44 am
OLAP Product: TM1, Transformer
Version: TM1 9.5
Excel Version: 2007

Re: Variable of TI process and Perspectives for Excel

Post by Maxon »

Alan Kirk wrote:
Maxon wrote: I create TI process. Result of TI process is number.I put number to TI Variable.
Can I connect through Perspectives for Excel to this variable(to Result of TI process) and show this Variable in Excel?
Many sites have a cube which is used to control the execution of TI processes or chores. Those cubes contain things such as parameters that are read in the Prolog. They can also be used to store output from a process.

The easiest way to do what you're after is to write the result of the process to a control cube via CellPutN or CellPutS, in which case the user can simply read the value from the control cube via a standard DBRW formula.
Thanks, but We have done this way.
We want connect dirrectly to result of TI process.
Perhaps, you know another way?
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Variable of TI process and Perspectives for Excel

Post by lotsaram »

no there is no other way
Post Reply