Action Button issue

Post Reply
Rosanero4Ever
Posts: 54
Joined: Thu Oct 18, 2012 5:08 pm
OLAP Product: Cognos TM1
Version: 10.1.1
Excel Version: 2010
Location: Italy

Action Button issue

Post by Rosanero4Ever »

Hi all,

I create a simple spreadsheet with an action button linked to a process.
This process has 3 parameters in input (please see the attached image)
With this setup, the process works well
With this setup, the process works well
process_works.jpg (88.82 KiB) Viewed 2987 times
After inserting the button I tested the functionalities immediately and they worked well.
So, I saved the spreadsheet.
After a day I opened the same file and I noticed that action button parameters was in an incorrect form (see the attached image please) and the action button doesn't work.
I have found this process setup. Obviously the process doesn't work
I have found this process setup. Obviously the process doesn't work
process_doesn't_work.jpg (86.35 KiB) Viewed 2987 times
Does anybody can tell me the reason of this issue and how can i solve it, please?

Regards
declanr
MVP
Posts: 1831
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Action Button issue

Post by declanr »

This is a known issue/bug and I can't off the top of my head remember whether it was the version of excel you were using combined with TM1 version etc.

But to avoid stuff like this I tend to always save the books in Excel 97-2003 xls format as opposed to xlsx, try that and see if you have the same issue?



Edit - From what I remember it was an issue of using a version of Excel that wasn't fully compatible with your version of TM1 e.g. TM1 9.5.1 with Excel 2010... but I noticed that you are using TM1 10 so I might be thinking of a different issue altogether
Declan Rodger
Rosanero4Ever
Posts: 54
Joined: Thu Oct 18, 2012 5:08 pm
OLAP Product: Cognos TM1
Version: 10.1.1
Excel Version: 2010
Location: Italy

Re: Action Button issue

Post by Rosanero4Ever »

Great!
I saved all my spreadsheet in XLS formato and now all work well!
Many thanks!!!
Post Reply