Grouping DFMEA Optimization columns for export

Question

Good morning,     Since BIRT is a pretty hard tool to generate the export, at the moment, we are usin an Excel macro to generate an output readable outside Medini and compliant to AIAG-VDA format for the DFMEA.  Unfortunately the script doesn't menage the case in which there are multiple  Recommended action and Action taken, for this reason the purpose would be to create a column in which is possible to merge multiple items if present.  I've already tried to create a coulm named "Grouped Recommended Actions" with the following script but it really doesn't work.  Under FMEA Recommended action I've created the following script:     var result = new Array();
  var list =  self.element
  for ( i= 0; i<list.size(); i++)
  {
   result.push(list.get(i));
  }
  var output = java.util.Arrays.asList(result);
  output     Could you please give me some help on this topic?  Best regards

medini_1063548292 · Answer

Hi Simone,     So if i get it correctly you want have column where you can collect all Actions ( Recommended,Taken) in FMEA context     Recommended actions:    contained in Current Design Control via recommendedActions.    Taken actions:    contained in Recommended action via takenActions   So I would create a derived profile property (OCL) for a Current Design control , one for recommended and one for Taken actions.        OCL code for Recommended Actions derived property  -- OCL @ Current Design Control
self.recommendedActions    OCL code for taken actions derived property  -- OCL @ Current Design Control
self.recommendedActions.takenActions     Result?          Hope it answers your question      Happy reporting,  Marian