Looking for a validation rule to validate data after transformation and before loading to the cube.
I have Import/validate/Load workflow. After the validation step , I want to run a business rule that can do the following - 1. Sum up the amount for all records with the same Product code in the tr...
Could you not use a Target Derivate Rule for this?
A target Derivative Rule allows you to run logic on the post-transformed data. You could sum your records and verify they are equal to zero using the Check Rule Derivative Type. If it fails you won't be able to load to the Cube.
If you have access to the Golfstream App, there is an example of how to construct the Derivative Rule and the Complex Expression to evaluate what to do when the amount = 0 and what to do when it does not = 0
