I am having serious performance issues when trying to execute a query with the following structure.I am told the
query returns 70000 records and i am displaying it through a portal.
Can any one suggest how do i built aggregates on the basis of the structure below
Fiscal year variant
Vendorid (user keys in the range of vendor ids ex ven001 to ven999(using variables)
Fiscal year variant(user keys in the range of period ex 10/2001 to 10/2006 (using variables)
Cost of product sold