Defining Rule Calculation

[krithika331]

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 !!

[Alan Kirk]

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?

[krithika331]

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 !!

[jim wood]

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.