TM1 Forum

Hi All,

My issue is when [ '0 AR Adjustment] is calculated it is not properly fed . There is an issue when we filter on a second dimension in the cube.

Cube has 2 customer dimenison,customer and customer type , it works fine when ALl customer types are selected , but when you filter by specific customer type , the values for other customer are also retained instead of making it zero . And total AR View is top level in the dimension and it has n and c elements in it .

SKIPCHECK;
# AR scoring Starts
[/img][/img][/img][/img] # AR Percentage Calculations based on the Buckets with respect to Total AR , Higher the percentage the risk of payment is more)
['AR% 0'] = if(['Current AR'] = 0 ,0,(['Current AR'] \ ['Total AR View']));
['AR% 1 - 30' ] =if(['Past Due 1 - 30' ] =0,0,(['Past Due 1 - 30']\['Total AR View']));
['AR% 31 - 60'] =if(['Past Due 31 - 60'] =0,0,(['Past Due 31 - 60'] \['Total AR View'] ));
['AR% 61 - 90'] =if(['Past Due 61 - 90']=0,0,(['Past Due 61 - 90'] \['Total AR View']));
['AR% 91 - 180'] =if(['Past Due 91 - 180']=0,0,(['Past Due 91 - 180'] \['Total AR View']));
['AR% 180+'] =if(['Past Due More than 180']=0,0,(['Past Due More than 180'] \['Total AR View']));
# AR Adjustment is applied when AR Balance is 0 or negetive meaning they dont owe anything and will recieve the full points
['0 AR Adjustment']=if(['Total AR View']<=0, DB('AR Parameter Scoring', '0 AR Adjustment', 'Values'),0);
# AR Adjustment is applied when AR Balance is 0 or negetive meaning they dont owe anything and will recieve the full points

FEEDERS;

['Current AR'] => ['AR% 0'] ;
['Past Due 1 - 30' ] => ['AR% 1 - 30' ] ;
['Past Due 31 - 60']=> ['AR% 31 - 60'] ;
['Past Due 61 - 90']=> ['AR% 61 - 90'] ;
['Past Due 91 - 180']=> ['AR% 91 - 180'] ;
['Past Due More than 180'] => ['AR% 180+'] ;

Thanks,

Analytics123 wrote:Hi All,

My issue is when [ '0 AR Adjustment] is calculated it is not properly fed .

FEEDERS;

['Current AR'] => ['AR% 0'] ;
['Past Due 1 - 30' ] => ['AR% 1 - 30' ] ;
['Past Due 31 - 60']=> ['AR% 31 - 60'] ;
['Past Due 61 - 90']=> ['AR% 61 - 90'] ;
['Past Due 91 - 180']=> ['AR% 91 - 180'] ;
['Past Due More than 180'] => ['AR% 180+'] ;

Thanks,

Because it is not fed at all. Out of all the feeders above, I can not see any that would feed [ '0 AR Adjustment]

I am not sure how to feed for the below rule ,
['0 AR Adjustment']=if(['Total AR View']<=0, DB('AR Parameter Scoring', '0 AR Adjustment', 'Values'),0);

Can anyone please help with the feeder statement .

Thanks,

Analytics123 wrote:I am not sure how to feed for the below rule ,
['0 AR Adjustment']=if(['Total AR View']<=0, DB('AR Parameter Scoring', '0 AR Adjustment', 'Values'),0);

Can anyone please help with the feeder statement .

Thanks,

7) Give a brief outline of what you've done to find the answer; which manuals or guides you've looked in, and what tests you've done. TM1 documentation isn't the best or most logically organised, and nobody expects new users to be able to find things which are obscure. It's OK to ask a question which more experienced users might consider obvious; we've all done it. However if the person answering your question knows what you've looked at, they won't waste your time or theirs by telling you what you already know. At a minimum, you should ensure that you browse the FAQ thread and use the search box in the top right to see whether there is already a solution to your problem. Also, please don't ask very basic questions about how to do things in TurboIntegrator or Rules without at least looking through the relevant functions in the Reference Guide.

I had this feeder in place .But doing a zero suppression removed the ['0 AR Adjustment '] measure from the cube even if it had values .
['Total AR View'] => ['0 AR Adjustment'];