Data Import Step - Load validated records
We are looking for a load into a financial cube. Mappings are already done in the source system. Is there a way to load records that pass the validation and write the other records to an error protoc...
Forum Discussion
As rhankey says the best way is probably adding a TransformationEventHandler script and execute it at the end of the process. I would use a method rather than WriteTransformedData. The StageSummaryTargetData method gives you all the transformed data. It takes 4 parameters: {Workflow Profile Name}{Scenario Name}{Time Name}{Filter}
eg {MyEntity.ICO balance load}{ACTUAL}{2025M1}{IcT = '(Bypass)' Or AcT = '(Bypass)'}
You can then fill out the rest of the filter with the other dimensions and that will give you a recordset of the rows that will not be loaded into the cube.