Hello,
We currently have several QV dashboards which consist of 3 Tier architecture. Tier 1 loads raw data, Tier 2 Manipulates the data, and Tier 3 is simply a way to view the data. We are experiencing an issue, following a load from Tier 1 where we set the type of a field to be text using the Text(Field) function and then store it into the QVD, when Tier 2 loads that data it seems to lose that conversion. Our data is semi-alpha-numeric meaning that some of it contains letters and numbers and some of it is purely numbers. All of our data needs to be viewed as strings.
Generally speaking we would be fine forcing that conversion at all tiers but we lose the optimized load when we do that. Has anyone had any similar experiences?
Thank you,
Clayton
