COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: que1983 on 12 Mar 2016 11:00:04 AM

Title: Aggregate data item error
Post by: que1983 on 12 Mar 2016 11:00:04 AM
This is the error message when I attempt to build a chart based on code in my program

Unable to build the aggregate dataItem="Weekly - Total". The referenced dataItem="LOCK EXPIRATION DATE" was not found at the same nesting level.

I chose the following:  Series primary axes=Weekly Recived total and Weekly not received total
Category = Lock Expiration Date (I want to be able to show each date per week in a range.  For example 02/23/16-02/26/16 with a weekly total of 215 for received and 298 for not received
Deafult measure axes I chose Weekly total to capture the totals per week.  I do not know why I get the above named error.
Title: Re: Aggregate data item error
Post by: BigChris on 14 Mar 2016 08:57:26 AM
Are you using relational or dimensional data?
Title: Re: Aggregate data item error
Post by: que1983 on 14 Mar 2016 09:12:58 AM
Relational reporting style