I hate CRUD development. I hate "business logic", or LOB apps, or basically anything "enterpriseish". Precisely because it isn't interesting... to me at least. Anything highly mathematical, involving neural nets, hidden markov models or genetic algorithms is what I like to code. Hell, I'll work on a team that codes a RDBMS, but f**k if I ever making a living solely coding against one.
Have use used the SQL Analysis Services? If you have some time, get the evaluation copy and try using the Excel Datamining Add-in to get started with seeing what you can put in and spit out. When you get your head wrapped around that, you should be able to program against it or at least have a better understanding of what kind of problems can be solved with this class of tool.