Validating Transformation Files 
Use this function to validate transformation files prior to running them to prevent transformations from erring out when running in production.
Prerequisites
The ValidateRecords keyword has been set to Yes in the transformation file. When set to Yes, the system validates the data during the process of validating transformation file. The system also checks to see if the converted member exists in the current dimension. If it does not exist, the record is rejected. When the ValidateRecords keyword is set to No, the system does not perform this checking during the transformation process. If some members are converted incorrectly, the system rejects the data during writing process.
Features
After running a transformation file validation, you can view a status log of successful and unsuccessful tasks, the output file of the transformed data, and any rejected data.
You can save the status log information in a Microsoft Excel workbook or a text file.
Activities
To validate transformation files, choose Validate transformation definitions from the Transformation Maintenance Options action pane, select a data type, and select a data file.
To change the information displayed in the status log, choose the appropriate view option.
To save the information displayed in the status log, choose Save in Excel Workbook or Save as Text File.