Page 1 of 1
Creating TM1 Button or Excel Button to Run 2 Process or Chor
Posted: Tue Mar 23, 2010 6:27 am
by appleglaze28
I have this cube that I write a data extract it to csv the imported to create a dimension. Is there anyway to create a button to execute 2 TI or 1 process. Since my process zero out the data in the cube and writing a csv file. If 1 user click 1 process to create & clear the view and wasn't able to click the other button to load the data. Another user might click the process to create & clear the data without even the first user loading his data first. So whatever he wrote will be overwritten by the 2nd user.
Re: Creating TM1 Button or Excel Button to Run 2 Process or Chor
Posted: Tue Mar 23, 2010 7:54 am
by Steve Rowe
Hi Appleglaze,
Can't you write one TI that calls both the other TIs using Execute Process and then call this control process from the action button?
Cheers
Steve
Re: Creating TM1 Button or Excel Button to Run 2 Process or Chor
Posted: Tue Mar 23, 2010 8:41 am
by lotsaram
I agree, simply run one process from the other! You can also parameterise the name of the process to be run as a cell or name reference. So without too much difficulty you could have a formula in the cell driven by a validation list that the user selects the task that they want to do ("upload file", "update dimension", "zero out view", etc.) and then the action button will fire the appropriate process.