TM1 Forum

Hi,
Problem:
We have forecasting cube for users to forecast units & ASP by quarter and region for products and we calculate $Value from it. Few users sometimes put some units and forget to input ASP which results in $0's but when we look at consolidation level like yearly, then TM1 consolidates units at year level which includes the units which has no ASP as well which understates the ASP at the year level.

Need Solution For:
Can we restrict user to submit his node in contributor web if any of these kind of incomplete forecast ?

Thanks for reading....

Hi
This would be a great feature indeed, Cognos Planning provides this functionality while it is not built in to TM1 at this stage
I guess you could try to tweak the Prolog of the tp_... TI process that is executed when someone tries to submit a node and prevent submitting this way.

Or at least you could either provide an active form with conditional formatting (I have done this a few times, highlight rows with <>0 volume but with price =0), or write an own TI that can be executed from a websheet and that looks for missing ASPs. Then hope your users are clever enough not to submit if there are missing prices.