Page 1 of 1

TM1 10.2.2 parameters all merged into one for xlsx excel

Posted: Fri May 22, 2015 3:42 am
by wonghyjason
We recently upgraded TM1 to 10.2.2 version, and as suggested by the TM1 guide, we converted the xls excel into xlsx excel but found the parameter list will merged into one single parameter value. :o
So far, we cannot found any solution or workaround on this issue, please help, thanks. :oops: :oops:

Beside, we tried to use xls excel format but no luck.When open them through TM1 Wee, the browser no longer open them as previous version but ask you to save the excel instead. :|

Re: TM1 10.2.2 parameters all merged into one for xlsx excel

Posted: Fri May 22, 2015 10:26 am
by whitej_d
The work around is to set your action button to get process info from sheet, and then use a range to define the parameters. This is much more reliable than selecting the parameters one by one as you have done.

Alternatively, if you recreate the action button, you should be able to set it up again with separate parameters.