Print Page - Can the aggregated result of a query be used in another query?

Title: Can the aggregated result of a query be used in another query?
Post by: seballen on 08 Feb 2012 08:46:04 PM

Hello,

Can I calculate the Total of some count or sum in one query and then just save that number as a variable to be used in additional queries?

Thanks,
Sasha

Title: Re: Can the aggregated result of a query be used in another query?
Post by: blom0344 on 09 Feb 2012 03:17:16 AM

Theoretically only by joining queries locally and using the resulting set to perform calc. However, I think you are after another mechanism..

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: seballen on 08 Feb 2012 08:46:04 PM