TM1 web and Combo/list boxes

[tosca1978]

Hi all,

I am using TM1 web for the first time (version 9.5.2). I have created an input sheet in excel with combo boxes and these do not work in TM1 web - they appear without the text. I have tried re-sizing the boxes, using list boxes instead - both through Form Control and through Data Validation (list as source etc) and none of them work.

According to this document on the IBM website combo boxes and list boxes are supported in TM1 web (this document is referring to 9.1 but I cannot find a later version).

http://public.dhe.ibm.com/software/dw/d ... niques.pdf

On Page 9 it is very vague about how you get control objects to work in TM1 Web. Can anyone shed any light?

Cheers

[tosca1978]

Update on my last post............

I have a list in excel using data validation, the source for the list is a named range "Country". Each cell in the named range is TM1 formula using ELCOMP and index. When opening the workbook in TM1 Web the list box does not work - blank text appears.

If I change the source of the list to a range of cells with hard coded values the list box works in TM1 web - all of the text appears in the drop down and is available to select.

This does not help me much as I need the source of the list box to be dynamic. There are 3 list boxes in total and the source of each one is a list of dimension elements that will change depending on the previous selection.

So i'm still stuck...any help much appreciated.

Cheers

[tomok]

According to this document on the IBM website combo boxes and list boxes are supported in TM1 web (this document is referring to 9.1 but I cannot find a later version).

I don't use Excel combo boxes when creating web sheets because they are so flaky in TM1 Web. I've never had any problem with data validation though, and I used it all the time before TM1 added the picklist functionality. Just make sure the list of values references a range in the workbook, not a hard-coded list, separated by commas and it should work. You also need to make sure the column is wide enough to display the items in your list.

On Page 9 it is very vague about how you get control objects to work in TM1 Web. Can anyone shed any light?

Welcome to TM1 Web

Update (based on your post while I was writing). I use dynamic lists like this all the time. You probably have to calc the sheet to make the drop-down work. Are you checking to see if the list works before recalcing?

[tosca1978]

Hi Tomok,

thanks for your post.

In excel I have turned on automatic recalc (I normally never have this switched on however, this "Menu" sheet will be the only one loaded to TM1 web with auto calc on and it just means that the dynamic lists will recalc straight away). In excel the drop down list works as expected and the column it sits in is wide enough. However, when opened through TM1 web I still get bank text in the drop down (the country that is already highlighted in excel appears but nothing below when you click on the cell). If I switch the source back to hard,coded values again the TM1 web works.

I have just created a new worksheet with a list of hard coded countries in column A, formulas in column B to = A and named the list in Column b as a range. Created a drop down list off this range and opened in TM1 Web - the drop down list works fine. (I only used formulas for the named range to see if it was an issue using formulas).

I then replaced the formulas with "=ELCOMP("tm1_tcms:PAAR_AFE",INDEX(H$3:H$499,$H$2),CELL("row",AA1))", This works in excel but again when I open in TM1 web the text is missing.

So all I can depict so far is that it does not like me using the Elcomp formula in the source of the drop down list for some reason. Seems strange.

If you have any ideas I'd be grateful to hear.

On a separate note - you mentioned that you used to use these dynamic lists before picklists came along. I contemplated using picklists as I tested these and they worked in TM1 web. However, I couldn't figure out how I could make it dymamic. Using the elcomp dynamic list route the user would:

1. Select country
2. Select a region (which is a component of the country they selected)
3. select a project (which is a component of the region the selected)

Not sure how I would achieve this with picklists.

Cheers

Mike

[tosca1978]

Tomok - another update!

I have switched the formula in the source of the drop down list to:

=SUBNM("tm1_tcms:PAAR_AFE",$K$10,ROW(M1))

The drop down list now works in TM1 Web. Not sure why the other formula did not work - I think that it should have done.

I'd still be interested to hear about how you would use Picklists instead though - and if that is best practice as I can always change the design.

Cheers

[Michel Zijlema]

I then replaced the formulas with "=ELCOMP("tm1_tcms:PAAR_AFE",INDEX(H$3:H$499,$H$2),CELL("row",AA1))", This works in excel but again when I open in TM1 web the text is missing.

The error is not in the ElComp formula - the CELL function is not supported in TM1 Web.

Michel

[tosca1978]

Michel,

Many thanks for pointing that out - much appreciated!

Cheers