“Premature optimization is the root of all evil” – Knuth
One of traditional challenges of Business Intelligence is that the data is Large. Large being the technical term for data that is big enough to cause problems. So the first thing that most BI architects do is to ignore Knuth, and to start designing around problems that they think might exist.
Read the rest on the Optimal BI blog.