Cube Rule not working the same in 10.2 as 9.5.1

[RNB]

['Open Forecast', {'USD Translation Rate', 'USD Actual Rate'}]=N:if(!FinanceGLPeriod@<=DB('Finance Constants','Constant Current Fiscal Period','StringValue'),['Actual','USD Actual Rate'],continue);
['Open Forecast']=N:if(!FinanceGLPeriod@<=DB('Finance Constants','Constant Current Fiscal Period','StringValue') ,['Actual'],continue);

Once the FinanceGLPeriod is <= the 'Constant Current Fiscal Period' most of the data for the prior months is set to zero for the 'Open Forecast' Even though the data exists in the 'Actual' version. This code works in the 9.5.1 version but not the 10.2 version. Can anyone see why this is producing disparate results between the two versions?
Thanks,
RNB.

[tomok]

Have you tried replacing the shorthand code on the right hand side with full longhand DB references?

[rmackenzie]

Your code is flawed because you are testing using @<= instead of <=. Testing numeric inequality on strings exposes you to a lot of problems to do with sort orders/ character encoding etc. I'd suggest you re-code this logic like so:

Code: Select all

['Open Forecast', {'USD Translation Rate', 'USD Actual Rate'}] = N:
  if( ATTRN ( 'FinanceGLPeriod', !FinanceGLPeriod, 'Period Number' ) <= DB('Finance Constants','Constant Current Fiscal Period','Numeric Value'),
    ['Actual','USD Actual Rate'],
    continue );

Note I've assumed you need a numeric attribute on FinanceGLPeriod and a numeric measure in the measure dimension of your Finance Constants cube.

Try this in Excel if you're not sure what I am talking about:

Code: Select all

=IF("3"<="11",TRUE,FALSE)

Re your TM1 version - the TM1 engine developers do make undocumented tweaks to tighten up the rule engine and presumably they've done something to impact this code given they need to think about a number of string encoding implementations e.g. ASCII and UTF-8 and what-have-you.

[Wim Gielis]

Code: Select all

=IF("3"<="11",TRUE,FALSE)

or:

Code: Select all

="3"<="11"

If we want 1 or 0 as the result:

Code: Select all

=--("3"<="11")

[/off-topic]

[rmackenzie]

I guess that the OP has their financial periods coded as 01, 02, 03 ... 11, 12 so the comparison has always worked, e.g.

Code: Select all

="03"<="11"

resolves to TRUE, even though:

Code: Select all

="3"<="11"

does not.

I assume something like this regularly does the rounds at IBM.

[declanr]

What exact version of 10.2 are you on?
The base version saw a few issues with how rules were handled (and the first couple of fix packs even.)

[RNB]

Thank you so much. This is so helpful I appreciate the help very much.
I'm on 10.2.2 and it seems fully qualifying the right side of the equation with the dimension name [Dimension:'Actual',Dimension:'USD Actual Rate'],continue);
corrected the issue. Now I will need to start looking at the code itself to try the improvements suggested.
Thanks again for the help!