Hi All, I'm relatively new to the Cognos world, so forgive the naievete of this question. I want to generate a report in Query Studio that produces the following:
Unique Patients for 2008
Gender # Patients
male 13,044
female 15,304
My underlying data and metadata is based on visits, not unique patients. So first I think I need to do a count distinct or something similar to get the unique patients. And then group/summarize by gender.
I can do this easily in straight SQL by writing a subquery that gets the distinct patients, then grouping and counting in an outer query. I'm sure I can do this in Report Studio -- but can this sort of thing be done in Query Studio?
Thanks in advance for your help.
IMHO QueryStudio generates always only one query. You are not able to create your own subqueries. it is only possible as you already mentioned in ReportStudio.