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

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

Started by seballen, 08 Feb 2012 08:46:04 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

seballen

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

blom0344

#1
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..
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite