Creating TM1 Button or Excel Button to Run 2 Process or Chor
-
- Regular Participant
- Posts: 269
- Joined: Tue Apr 21, 2009 3:43 am
- OLAP Product: Cognos TM1, Planning
- Version: 9.1 SP3 9.4 MR1 FP1 9.5
- Excel Version: 2003
Creating TM1 Button or Excel Button to Run 2 Process or Chor
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.
- Steve Rowe
- Site Admin
- Posts: 2456
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Creating TM1 Button or Excel Button to Run 2 Process or Chor
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
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
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- MVP
- Posts: 3703
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Creating TM1 Button or Excel Button to Run 2 Process or Chor
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.