tm1 rules C level and Ascii extract
Posted: Tue Jun 15, 2021 2:52 am
Hi ,
I have a cube with 5 years of sales data at day level . I have a rule to calculate Revenue Per day at Month level(C) .
I have the below rule and feeder . I extract flat files from tm1 to asciioutput for few measures and when i do it for this rule based measure it takes a lot of time to extract data at month level.
Rule :
['Input Currency','H1 RPD']=C:IF((ELLEV('Time Period',!Time Period)=1 % ELLEV('Time Period',!Time Period)=2) & ELISANC('Time Period','All Calendar Years',!Time Period)>0,
['Full Revenue']\ATTRN('Months',ELPAR('Time Period',!Time Period,1),'Business Days'),0);
['Input Currency','H1 RPD']=N:IF(['Full Revenue']<>0,0.000000001,0);
Feeder:
['Full Revenue'] => ['H1 RPD'];
I create a view on the fly and then do a ascii output .
I dont have any other code in my ti process .
I think it takes more tiem becase of the rule calcualtion and feeders, is there a better way to write this rule .
Thanks,
I have a cube with 5 years of sales data at day level . I have a rule to calculate Revenue Per day at Month level(C) .
I have the below rule and feeder . I extract flat files from tm1 to asciioutput for few measures and when i do it for this rule based measure it takes a lot of time to extract data at month level.
Rule :
['Input Currency','H1 RPD']=C:IF((ELLEV('Time Period',!Time Period)=1 % ELLEV('Time Period',!Time Period)=2) & ELISANC('Time Period','All Calendar Years',!Time Period)>0,
['Full Revenue']\ATTRN('Months',ELPAR('Time Period',!Time Period,1),'Business Days'),0);
['Input Currency','H1 RPD']=N:IF(['Full Revenue']<>0,0.000000001,0);
Feeder:
['Full Revenue'] => ['H1 RPD'];
I create a view on the fly and then do a ascii output .
I dont have any other code in my ti process .
I think it takes more tiem becase of the rule calcualtion and feeders, is there a better way to write this rule .
Thanks,