Creating TM1 Button or Excel Button to Run 2 Process or Chor

Post Reply
appleglaze28
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

Post 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.
User avatar
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

Post 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
Technical Director
www.infocat.co.uk
lotsaram
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

Post 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.
Post Reply