COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Query => Topic started by: lucky123 on 01 Dec 2011 11:49:13 PM

Title: generating distinct and over() in report studio
Post by: lucky123 on 01 Dec 2011 11:49:13 PM
Hello All,
            I have a query item which is the sum of two other query items(eg: sales_amt+overhead_amt). When I use this query item in report studio it is generation a query with distinct and ove() by clause. It is killing the DB. I would appreciate your feedback on this issue.
Thanks