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

 

News:

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

Main Menu

count function performance issue

Started by mathil, 24 Aug 2012 04:08:01 AM

Previous topic - Next topic

mathil

Is there a way to improve performance on the count function in report studio. I want to count the number of orders with a revenue larger than 0 per sales staff. The order dimension is of course very large as is the client dimension. I have tried different approaches all having a very negative effect on performance. What would the best practice solution to this problem.

Creating count as:

count([order] within set( filter([order]; [revenue] > 0 ) ))

Adding a count to the table doesnt seem to help either.