TM1 Forum

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.

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?

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

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.

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