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:
Quote:
|
All I would choose is excel file and what is counted as Out Of Boundary. So what is counted as being Unacceptable which is what I want to have reported BUT this doesn't mean the tool I am looking for would compare just those filters related to the subject of what I would define. Everything needs to be included. Everything, even the parameters/values NOT used because they might still effect the ones used.
|
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.