TM1 10.2.2 parameters all merged into one for xlsx excel

Post Reply
wonghyjason
Posts: 7
Joined: Wed Feb 06, 2013 2:23 am
OLAP Product: Cognos TM1
Version: 10.1
Excel Version: 2007

TM1 10.2.2 parameters all merged into one for xlsx excel

Post 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. :|
Attachments
merged xlsx parameter
merged xlsx parameter
merged.png (22.43 KiB) Viewed 2139 times
normal xls parameter
normal xls parameter
normal.png (3.4 KiB) Viewed 2139 times
whitej_d
Community Contributor
Posts: 103
Joined: Mon Sep 05, 2011 11:04 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

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

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