TM1 Web picklist

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

TM1 Web picklist

Post by appleglaze28 »

I don't really know anything about the website or web base application but I encountered that I created this websheet and the picklist doesn't drop down on the same location as it suppose to be as the websheet template is designed. I noticed some picklist do drop down on the same column and some end up being like 4 columns on the left from the location of the template...is this just natural or is there anyway to adjust this.
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: TM1 Web picklist

Post by tomok »

Do you have any hidden columns in the Excel sheet? Hidden columns often throw off the column alignment when opened in TM1Web. Unhide them and/or move them out just to the right of your report range.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
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

Re: TM1 Web picklist

Post by appleglaze28 »

no hidden column just merged ones...its unavoidable to use merging of column to make the excel websheet more easy on the eyes of the user
mberson
Posts: 30
Joined: Tue Jun 07, 2011 8:30 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: 2016

Re: TM1 Web picklist

Post by mberson »

I'm experiencing this same issue - version is 9.5.1
On some websheets, it's working fine. Larger ones with more formatting, it's getting thrown off and appearing to the left of the actual cell. In some instances, I have to scroll to find the actual list.

Any thoughts appreciated....
Matthew Berson
ACG TM1 Consulting
mberson
Posts: 30
Joined: Tue Jun 07, 2011 8:30 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: 2016

Re: TM1 Web picklist

Post by mberson »

Not sure how I missed this the first go around on IBM/Google/OlapForums
This is a bug with 9.5.1 - Fixed in 9.5.2 FP1

http://www-01.ibm.com/support/docview.w ... wg1PM24299
Matthew Berson
ACG TM1 Consulting
Post Reply