Yes, I'm aware that the Business Warehouse (BW) database has a reporting tool named Business Explorer (BEx).

That aside, it seems you're using a highly customised product whose customisations and capacities you don't understand. I'd suggest discussing those issues with whoever is responsible for BEx maintenance & programming in your organisation and find out. If no-one there can help you, contact BW.

If you're considering any form of automation, you'll need to learn how to code the BEx object model (if it has one). Again, BW should be able to provide some advice. If BEx doesn't have a programmable object model, you'll probably have to investigate alternatives.

Once you've done that, you'll still have to program whatever package you use. Simply saying:
is nonsense. Query parameters do not affect the data and you can't analyse what you haven't defined as a query parameter. If, as you suggest you're simply going to "compare everything with everything else" regardless of the parameters specified, what you're really saying is that you want a parameter-less analysis. Can't be done. And, if you specify every possible permutation and combination as the parameters you'll never get meaningful results.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]