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:)
Variable of TI process and Perspectives for Excel
-
- 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
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.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?
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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- 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
Thanks, but We have done this way.Alan Kirk wrote: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.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?
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.
We want connect dirrectly to result of TI process.
Perhaps, you know another way?
-
- 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
no there is no other way