COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cognosehelp01 on 13 Jan 2015 11:37:02 AM

Title: Master-Detail Relationship
Post by: cognosehelp01 on 13 Jan 2015 11:37:02 AM
Hey guys,

Had a question:
I am using a master-detail relationship to get Discrepancy information on an object filtered by the object.
Object1 - Discrepancy1
             - Discrepancy2
             - Discrepancy3
Object2 - Discrepancy1

I wanted to get the count of the Discrepancies per object in a new query outside of the master-detail list. but it wouldn't run in list mode and when I created a singleton to see the count of a single Object I got 'The reference to the 'Discrepancy Count' query creates a circular dependency.'

How should I go about trying to get the Discrepancy count per object?