hi,

I used OLAP some time ago, but not in SQLServer. the product was bought by Oracle a few years back. I worked in a Direct Marketing Co, and we used it to identify buying trends, customer retentions etc. Also was useful to identify liklihood of bad debters based on demographics, product mix etc. It was used together with a stats package - but as I say, this was about 5 years ago.

I enjoyed using it, but alas haven't had the opportunity since.