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]

There is no way I could discuss with my organization what I am asking here. Noone knows that, thats why they are wasting time with manual analysis.
I apologize but I disagree on your comment saying I cannot analyze what isn't defined. In above example, I haven't defined color of skin, favourite sport, favourite book, etc. However it is very possible that (random chosen SUBexample on previous example) people, whos favourite sport on parameter ''Indoor Team Sports'' (parameter of filter) is Volleyball (value), are too many (too many persons) and cannot accept all of them for (randomely saying) membership from X country (given filter) in Y continent (given parameter of filter).

Here I just proved you what isn't defined can have major impact on results. Surely I must input what I am interested for BUT when I said ''what isn't defined'' I was referring to all high number of filters, their parameters, values of those parameters that are NOT enabled to be filtered. With ''to be filtered'' I mean where the datas on worksheet are shown only if meeting criteria of enabled filter. But as said I know I definitely have to define what I am interested for. However definitely must be compared everything.

However defining what I am interested for (=getting report from what data I want to get in order to see out of ordinary related data, one filter/parameter/value with another for purpose of getting the answer on question ''Where further work/improvement must be done?'') can be giant trouble if I want to see in general for entire Excel file what is going on. Even such definition of interest might be bigger waste of time than doing this procedure manually (without tool I am asking for) - I might need to define hundreds or thousands of interests (relations: e.g.: What is causing the Sale to be Reduced In particular month and year in X country) with same amount of defined boundaries (e.g. Sale is reduced if it goes below $500,000). The answer could be wrong material (filter = material) on wrong location (filter = manufactory's location) used, although I wouldn't filter the data based on those two filters.

Anyway my question still remains. Which tool could I use for this? Obviously tool has to be able to access everything from extremly isolated (but entirely located within Excel, except files aren't opened from hard drive but from some internal networking point) and customized addon: BW.