IMX, the core problem is that all BI software is built around the idea that everything is a financial value that can always be arbitrarily aggregated meaningfully, and that looking pretty is more important than presenting the data in a way that your organization actually finds logical.
It's a way to sell very expensive software to decision-makers, while also producing software complex enough that it can't be configured well enough to properly evaluate until well after you've already bought it. Only then do you find that the feature set is very broad, but very shallow. It's only 18 months later that you discover how limited the report writer is, or that you have to do it this one way for everything even if you really could use it formatted slightly differently.
It's like using a pivot table in Excel and trying to control the order of the columns, or to make one table aggregate two values distinctly, etc. You end up with 10 seconds to pull your data and create the table, and 4 hours trying to get it to display in the manner you want before giving up.