COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Query Studio => Topic started by: kskanth on 10 Aug 2010 12:34:38 PM

Title: Error in Query Studio
Post by: kskanth on 10 Aug 2010 12:34:38 PM
Hi all,

I imported and did reqd data modelling in FM.. and when I test the sample data it runs and gives the data correctly

but when I run the report in Query studio it is giving me some garbage values.. it is producing garbage values only when i add time columns to the report.. if not everything is going fine..

Can any one suggest me where i am going wrong..

Thanks
Title: Re: Error in Query Studio
Post by: MFGF on 26 Aug 2010 08:28:51 AM
Sounds very much like the data is not modelled appropriately in Framework Manager.

If you select the same set of items within Framework Manager, use the Test feature, check the 'Auto Sum' check box in the top right corner, then click 'Test Sample' at the bottom, do you see the same "garbage" results in FM?

MF.