TM1 Forum

Hi,

we have a picklist issue in TM1 Application, version 10.2.2.

We created a picklist as Dimension:Dim_Name, where Dim_Name has elements Y and N.
Everything works fine in Perspectives: the picklist is shown correctly and the cube is updated instantaneously.
However, when we deployed the form and opened it in TM1 Application we realized that the picklist was not working at all.
Indeed, we can see the scroll bar, but not the values (Y,N). However, input is correctly validated, i.e. we can only write Y,y,n or N in the cell.

Any ideas about it?

Thanks,

Chiara

Admin Note: Moved to the correct forum. This does not belong in General.

The TM1 Application you are referring to, is that in excel sheet/ Cube viewer or TM1 web?

Not sure if this will help in your case, but I saw Picklists have a different behaviour depending on what they are based on.
For example, large lists based on dim don't work in every GUI, but if exact same elements are part of a subset and this subset is used as alternative source, your Picklist works fine everywhere.

Gabor, Mems, thank you for your support.

The TM1 Application is an Excel sheet.

We could fix the issue with a workaround based on SUBNM and DBSS.
In the form we used SUBNM("Server_Name:Picklist_Dimension";"";1), where Picklist_Dimension is a dimension whose unique elements are Y and N, then we wrote DBSS(cell_with_subnm;"server_name:destination_cube";e1;e2;...;en) in a hidden cell.
Notice that in Perspectives it is now necessary to recalculate the sheet in order to write the value the user defines through SUBN cell into the destination cube.
This is not necessary in the Excel sheet deployed in TM1 Application.