KB286314: Metrics based on R script with recursive functions return blank in MicroStrategy Developer

SYMPTOM:
Metrics based on R script with recursive functions return blank in Strategy Developer 10.1.
 
STEPS TO REPRODUCE:

• Write a recursive function in “Yx.R”.
  Yx=function(y0,a,m,x)                                                         
  {                                                                                     
  Yx=(y0 * ((1 - (((x)**2)/(a**2)))**m))/100             
  return(Yx)                                                                 
  }
  Yx(y0,a,m,x)     
  

• Open Yx.R in deployR, uncheck the option “Nulls Allowed” and create the RScript.
  
  

• Create a metric “Yx” based on the RScript.
  
  

• Execute the report and the Yx column returns empty.
• Create another R file without any recursive function:
  Yx=(y0 * ((1 - (((x)**2)/(a**2)))**m))/100
• Follow the same steps to create metric “Yx – simple” based on the new R file and it returns values successfully.
  
  

CAUSE:
This is a known issue of Strategy Developer 10.1.
 
ACTION:
Currently this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled Strategy release.
The Strategy Internal Reference Number for the issue discussed in this technical note is DE29592.
KB286314