COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: bvk.cognoise on 23 May 2011 01:05:00 AM

Title: whatis the main diffrence between query calculation and data item?
Post by: bvk.cognoise on 23 May 2011 01:05:00 AM
Hi,

i have small confusion...what is the main difference between query calculation and datitem?


thanks
bvk
Title: Re: whatis the main diffrence between query calculation and data item?
Post by: blom0344 on 23 May 2011 03:35:21 AM
A query calculation is semi-unique for a report, whereas a dataitem is usually reused from a model
Title: Re: whatis the main diffrence between query calculation and data item?
Post by: bvk.cognoise on 23 May 2011 06:20:33 AM
Hi blom0344,

thank you very much for your reply.but im not able to understand it.can you please explain me it clearly?


thanks
bvk
Title: Re: whatis the main diffrence between query calculation and data item?
Post by: blom0344 on 23 May 2011 02:35:00 PM
Suppose your report fetches 2 facts (with other related dataitems) When you drag a new dataitem to the query and perform a subtraction with the 2 facts, then you are effectively creating a new query calculation. This exists in the report query, but not as a model query item
Title: Re: whatis the main diffrence between query calculation and data item?
Post by: bvk.cognoise on 24 May 2011 12:46:09 AM
Hi blom0344,

sorry for my mistake i did not asked my question clearly  :( .what i am asking is what  is the difference between Data item ,query calculation which is located in toolbox tab. we can create new calculated column using these two(Data item,query calculation).but in which case we use Data item and query calculation?

sorry for my uncleared question  :(

thanks
bvk