TM1 Forum

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:)

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.

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?

no there is no other way