2.02-13 Only use POST for its specific purpose

rob_marshall

Don't use POST for simple data offsets.  OFFSET, LAG or MOVINGSUM are more efficient

cvbhadri2002

What is the reason for it?

rob_marshall

@cvbhadri2002

What is the reason for what? Post can cause performance issues. If you are asking what the function is used for, you can find it Anapedia.

https://help.anaplan.com/post-082cb491-879c-4711-b5c6-9ed162391bb1

cvbhadri2002

why post should not be used for simple data set and how does post cause performance issue?

rob_marshall

@spectra7676

Because it can combine the value already there or multiple cells, and due to this, it checks every cell in the timescale. It is best to use next(), movingsum(), lag(), or offset().