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

Summaries in query Studio

Started by drakka, 08 Oct 2008 09:15:52 AM

Previous topic - Next topic

drakka

Our users are building queries in query studio using measures and the measures are automatically summarized. For example we have number of licences by fiscal year. The problem is that the summarization counts the number of cells that are populated instead of totalling the number of licences for every year, which means that we have some cells with numbers such as 200 but the summary gives us 18. My question is, is it possible to force query studio to do a total in the summary instead of a count? Does it have something to do with the regular aggregate property of the measure? (right now it is set as "count distinct") I'm fairly new to Cognos, thanks a lot for your help, let me know if you would like me to clarify my problem.