TM1 Forum

I have a cube where a dimension1 has an element1

I defined a picklist to element 1 in elements attributes as dimension:months
Dimension months contains months from Jan to Dec

So in the cube in the element1 in the dimension1 user can choose month. But I found a problem.
At first element1 is empty. When user put for example Dec. But after some time decided to return to empty value in the element1. But he can't do it because TM1 says "The value you entered is not valid. A user has restricted values that can be entered into this cell".

Does anybody know how to return to empty value if user chose any value from picklist?

picklist is data validation feature. It limits the value for that element to be 1 of the selected values. If the selection you provide does not a blank value, then you cannot have a blank value for that element.

Here is the explanation from the user guide:

Null Values in Pick Lists

All pick lists in TM1® Web (both Websheets and the Cube Viewer) always contain a null value that a user can select. The null value is automatically inserted into all pick lists in TM1 Web; it does not have to be explicitly defined.

Picklists in TM1 Architect and TM1 Perspectives only contain a null value if the pick list is a static type and a null value has been explicitly defined for the pick list. Dimension pick lists and subset pick lists can never contain a null value when used in TM1 Architect and TM1 Perspectives.

Selecting Null Values in Picklists

There are two ways to select null values from pick lists.

Steps

In any of the TM1® clients, you can click the pick list and then click the null value.

Important: In TM1 Perspectives slices and Active Forms, do not click the null value in a string cell. This will delete the DBRW formula from the cell and you will no longer be able to retreive data for that cell from the IBM® Cognos® TM1® server. You can safely click the null value in numeric cells.

In TM1 Web and Architect, you can press the Delete key in a cell containining a pick list to select the null value.

Important: Do not press Delete to select a null value in TM1 Perspectives slices or Active Forms. This will delete the DBRW formula from the cell and you will no longer be able to retreive data for that cell from the TM1 server.

Thank you for answer

It turned out that I can put empty values in Tm1Web and Contributor Client (described porblem was only in architect but users don't work in it. So the problem is solved.

user guide wrote:Dimension pick lists and subset pick lists can never contain a null value when used in TM1 Architect and TM1 Perspectives.

This is a bit a of a problem. But the workaround to this is to copy a space into clipboard and paste it into the cell that you want to clean.

mce wrote:

user guide wrote:Dimension pick lists and subset pick lists can never contain a null value when used in TM1 Architect and TM1 Perspectives.

This is a bit a of a problem. But the workaround to this is to copy a space into clipboard and paste it into the cell that you want to clean.

Yes - it works - thank you

Hi,

after installation of HF13 on TM1 9.5.1 i have a problem, that the null value, that automatically was there in TM1 Web is gone now. Now null value have to be in picklist itself, otherwise i get "Value not in Picklist", which is quit a problem, as we have many picklists going on dimensions and subsets.

Is there anything i can do about it? Is there something in config, i am missing? In Release Notes i can't find any hints regarding this topic.

Thanks.

I don't know when this was fixed but in 10.1.1. FP1, you can delete picklist-based string data in Cube Viewer, even if there is a subset behind the picklist.