COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: Anke on 05 May 2011 08:00:00 AM

Title: Way to change field in Model to not calculate in Report Studio??
Post by: Anke on 05 May 2011 08:00:00 AM
In Report Studio, a decimal value field is adding up when there are multiple rows in the report...I can change the aggregate from Auto to None to stop this from happening, but I was wondering...is there some way to change the items in the Model???  The end users  will consistently forget to change the aggregate to none when creating reports.
Right now, the table field in the modle is set to Usage: Fact and Regular Aggregate: Unsupported...the field type is a decimal.

Thanks!! :)
Title: Re: Way to change field in Model to not calculate in Report Studio??
Post by: Anke on 05 May 2011 08:16:51 AM
ekkk.nevermind, it wasn't changed in the TBL area.
got it, :)