If you are unable to create a new account, please email support@bspsoftware.com



MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

generating distinct and over() in report studio

Started by lucky123, 01 Dec 2011 11:49:13 PM

Previous topic - Next topic


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.