In my orders cube order qty is one measure..I created one
measure on so qty(measure) and set aggr funcion as count..
customer,time dimensions are there..I want to get no of
orders(twice,3-5 times,5-10 times) placed (count) for the
last 3 months.ie..output should like:

Last 3 months

no.of orders- only once 2-4 times 4-8 times
placed


customers(all) 800 200 80

How can i get the output??can anybody help

If your bands/groups of order counts are not determined by the cube
data, then this article should help you:

http://www.tomchester.net/articlesdo...icbanding.html

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!