Time's monthnum property can't be read numerically by script logic
I am working on a script logic that uses monthnum to list a set of time periods for an xdim. The select statement is supposed to list all periods with monthnum greater than or equal to the time_set.
The problem is months OCT, NOV, DEC (those periods with 2-digit monthnum) is not being read as greater than the FEB - SEP. If my time_set is YEAR.AUG, my select statement will list only YEAR.AUG and YEAR.SEP. What's weird is that when i tried running the same logic on a VMWARE environment with the same BPC version (7.5MS), it worked! What can possibly be wrong here?
Any inputs will be highly appreciated. Thanks.