COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: dwsudheer on 23 Aug 2011 12:52:35 PM

Title: Unable to build the aggregate dataitem!!!very urgent
Post by: dwsudheer on 23 Aug 2011 12:52:35 PM
Hello frens,

I am getting below error while running the report.

Unable to build the aggregate dataitem = "Total(OCN)". The referenced dataitem  = "OCN" was not found at the same nesting level.

frens this is very ureget help me out..Thanks in Advance..

--I saw the solution in IBM site ..ie to avoid this error you should nest(OCN) at the same level [Total(OCN)]...but how to do this ..Help me ..
Title: Re: Unable to build the aggregate dataitem!!!very urgent
Post by: Arsenal on 24 Aug 2011 10:02:06 AM
the total(OCN) is depending upon the dataitem OCN to be able to get its values. This OCN item must be present in the report and must also be at the same level of nesting (row or column) as where you're placing the total(OCN). If that is not possible, you may have to change the function you're using to calculate this aggregate.

Here, take a look at the solution given below for a similar issue and see if it helps:

http://www.cognoise.com/community/index.php?topic=6945.0
Title: Re: Unable to build the aggregate dataitem!!!very urgent
Post by: dwsudheer on 25 Aug 2011 05:47:26 AM
Hey ..Thauk You!! got resolved