TM1 Web 10.2.2 Dropdown issue

[dario]

We are having an issue with TM1 websheet that I am hoping you guys can help me with.
Dropdown is populated by SUBNM formula

Sometimes, but not always websheet does not recalculate.
For example:

select Jan---data appears for January
select Feb--- data appears for February
select Mar -- nothing happens and the sheet is still populated by February data.
wait a few moments and select Mar again and it is populated and then you can select different months a few times before it happens again
This happens intermittently across different browsers and versions thereof.

Log files show one error around the time which is:
2015-04-16 14:39:02,461 [http-9510-2] ERROR () com.ibm.cognos.tm1.websheet.calculation.formulaparser.PtgFunc$28 - Exception Error: null
Stack Trace: java.lang.NullPointerException

What is puzzling is that you can pick 10 months and it will not happen or you can pick 1 and on the second it will get stuck.
Opening new browser, clearing cache, restarting server, none of these helped

Any input would be greatly appreciated.

[lotsaram]

Either the cell is populated by a picklist in which case the cell will contain a DBR
OR
The cell is populated by a SUBNM

It can't be both so which is it?

[dario]

Cell is populated by SUBNM
=SUBNM("gl:Months","dashboard_months",$C$4)

[tomok]

Putting a SUBNM formula in a web sheet is not the same thing as using a picklist. Yes, clicking on a SUBNM formula brings up a list from which to pick but it is not a picklist as defined by TM1. That is an entirely different animal. Read the manuals if you want to know what it is. Since you don't have a picklist the RecalcOnPicklistChange parameter is not applicable.

[dario]

Thank you for pointing that out. Edited my post to remove all picklist references. Sorry for the confusion.