TM1 Forum

Hi All,

I had created a websheet in cognos TM1 Perspective which is having direct cube reference (Used DBRW formulae for the websheet cells).My cube have Picklist defined and the same was visible at perspective websheet level.

The actual problem is that after deploying the websheet to Cognos 10.2.2 App Web, not able to see the picklists.Can any one have any solutions for this?

Thanks.

Are you using static, dimension, subset or cube to define the picklist? If you are using a picklist cube then the users need to have read access to the cube for the picklist to display.

I am using dynamic control cube picklist.It is created by me only.So then , it should be visible for me right . But it is not.

I seem to recall seeing this once before with applications web (contributor) where the websheet was originally created without a picklist attached. Then when the picklist got created it didn't appear in the application until I opened the websheet through perspectives, recalced to confirm the picklist showed and then updated the sheet.

Can't recall if I had to then republish the application or not.

Sorry to bring back such an old thread from dead, but figured I should piggy back on this since it appears to be identical to my issue.

How were you able to resolve this issue? I have few pick lists that work fine in Excel active forms, however, when published to TM1Web the pick lists don't appear to even render the control nor show any data items in the pick list like they do in Excel active forms.

Our pick list is cube based (so we have control cube that has the pick list defined via using a subset) and we are on 10.2.2 FP4 with an Interim fix.

Also, we have quite a few other active forms that render the pick lists just fine on TM1Web and Excel and are also based on control cube and subsets.

Thanks in advance for any feedback/suggestions.

Hi deadsea,

I had the same issue and found that TM1 can't resolve the picklist if you defined picklist control cube and picklist attribute for the same measure/cube.
Just after adding all picklist definitions to Picklist control cube (make sure user group has at least read security on this cube) and delte picklist attribute from the measure dimension attributes it works perfectly.

So please try it or post your solution if you have different resolution.

m.eissa wrote: ↑Tue Jun 09, 2020 1:59 pm Hi deadsea,

I had the same issue and found that TM1 can't resolve the picklist if you defined picklist control cube and picklist attribute for the same measure/cube.
Just after adding all picklist definitions to Picklist control cube (make sure user group has at least read security on this cube) and delte picklist attribute from the measure dimension attributes it works perfectly.

So please try it or post your solution if you have different resolution.

It is quite strange to be resurrecting a 4 year old post! But since we are here ...
What you descrive shouldn't be the case and isn't the case in my experience. You can have both a PickList attribute and cube. When this is the case the PickList cube has priority. You can think of this as being exactly the same as cell security vs. element security; as long and the corresponding cell in the PickList cube has a value then this will be applied. Should the value in the PickList cube be empty then the PickList attribute will be applied.

Chances are you had an incorrect value in your PickList cube which resulted in a "NULL" PickList.

lotsaram wrote: ↑Tue Jun 09, 2020 2:49 pm What you descrive shouldn't be the case and isn't the case in my experience. You can have both a PickList attribute and cube. When this is the case the PickList cube has priority. You can think of this as being exactly the same as cell security vs. element security; as long and the corresponding cell in the PickList cube has a value then this will be applied. Should the value in the PickList cube be empty then the PickList attribute will be applied.

Chances are you had an incorrect value in your PickList cube which resulted in a "NULL" PickList.

First I wanted to disagree because I thought I experienced the same problem a while back but double checked it and looked it up in the documentation.
You are of course absolutely right. See here https://www.ibm.com/support/knowledgec ... 34234.html the official documentation.