TM1 Forum

Hi,

I have a rule calculation to be defined for ratio (x/y). I tried to define it in the general way as z = N: (x/y) and also z= C: (x/y) for both the Leaf and consolidation level. I came across a different situation where the resultant value is giving the some junk value (numeric with decimal) and the not the actual result of x/y. I am using 10.2 version. But when i have removed defining the qualifier (N or C) , i.e. z = (x/y) the ratio values gave me the correct values. I defined the Feeders for both x and y. But this will decrease the performance without defining the qualifier.

I didn't had this issue when worked with 9.5.2 version. Any ideas??


Thanks in advance !!

krithika331 wrote:Hi,

I have a rule calculation to be defined for ratio (x/y). I tried to define it in the general way as z = N: (x/y) and also z= C: (x/y) for both the Leaf and consolidation level. I came across a different situation where the resultant value is giving the some junk value (numeric with decimal) and the not the actual result of x/y. I am using 10.2 version. But when i have removed defining the qualifier (N or C) , i.e. z = (x/y) the ratio values gave me the correct values. I defined the Feeders for both x and y. But this will decrease the performance without defining the qualifier.

I didn't had this issue when worked with 9.5.2 version. Any ideas??

Do you have the AllowSeparateNandCRules parameter set in your tm1s.cfg file? If so, what is is it set to?

I have checked the Tm1s.cfg file and the value for AllowSeparateNandCRules parameter is T. Is there any other property to be set in the cfg file.


Thanks in Advance !!

Have you tried ['Z'] = (X\Y);

Or is the calculation different for both N and C? Also have you made sure that you are using \ and not /???

Jim.