I have a data reader that reads an ascii tab delimited file. It updates several cubes correctly. However, I have an issue with one of the transformations. I am reading text values and converting this to an integer based on the text value in the source file.
I have used various versions of the formula above including E & F columns to make the formula simpler. These formulas perform the correct transformation when I preview the values in the data reader e.g.
However, when I execute the data reader, the cube ends up with the default value (9 in this case). Has anyone else experienced this issue?