If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Junk Values coming in the categories of Upgraded cubes

Started by mycognos, 20 Aug 2010 02:26:23 PM

Previous topic - Next topic

mycognos

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......

                   

peritas-chris

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