Hi,
I have upgraded some cubes from Transformer 7.3 to 8.4 version, where I had some categories and security applied. While upgrading the models, I have removed all the categories and security and when I build the cubes in 8.4 version and open it analysis studio there are some junk values in the dimensions. But when I open in the transformer model and open the categories it is showing only the correct values alone. Can anyone tell me how to avoid these junk values?
Thanks in advance......
Hi there :)
What kind of junk values are you referring to? Remember, the categories in Transformer will not always represent every member that may appear in the data, especially if you build that dimension from a different data source than the measures. Have you been able to check the source data for the junk values?
- Chris