TM1 Web picklist
-
- 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
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.
-
- 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
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.
-
- 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
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
-
- Posts: 30
- Joined: Tue Jun 07, 2011 8:30 pm
- OLAP Product: Planning Analytics
- Version: 2.0
- Excel Version: 2016
Re: TM1 Web picklist
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....
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
ACG TM1 Consulting
-
- Posts: 30
- Joined: Tue Jun 07, 2011 8:30 pm
- OLAP Product: Planning Analytics
- Version: 2.0
- Excel Version: 2016
Re: TM1 Web picklist
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
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
ACG TM1 Consulting