The problem is that precision is expensive. Writing is thinking. Writing software is defining the business problem.
People don't know exactly what they want from the data warehouse, just a fuzzy approximation of it. You need stochastic software (AI) to map the imprecise instructions from your users to precise instructions the warehouse can handle.
Wait but this just sounds unhinged, why oh why